Can't sleep, spreadsheets will eat me

[debitha]

I know that some of you know and love your spreadsheets, but mine are sprawling and large and numerous and I don't know how to make them do what I want.

I will be getting Excel training soon, but that doesn't help me now so I thought I'd ask you guys, since you're a clever bunch.

I need to run a mail merge. I have a spreadsheet of dealer addresses, and I have a list of people who are attending my event. I am trying to find a way of getting information from each spreadsheet together (delegate details from one and address details from the other) so I can run a mail merge from one document. I know that you can do data pickups, but I don't know how, and I don't know what the parameters are in terms of what I can and can't make it do.

Please help!

Comments

[holding-pattern.livejournal.com]

Poosies, because I'm sure the lad knows how to do this, but he's in Melbourne and may not be checking his email regularly.

Me, I'm a spreadsheet baby. Sums n stuff, that I can do. IF functions and anything more complicated? Wibbling mess :).

[debitha.livejournal.com]

I feel quite certain this is something the lad would know. Oh well.

I'm pretty much at spreadsheet baby level too. But I just got shown v-lookups, which is where you tell one spreadsheet that every time a certain thing occurs, it should pick up certain information out of a whole different spreadsheet! Thereby saving me HOURS of copy/paste, copy/paste, copy/paste paste paste.

I really want an excel course.