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

[debitha.livejournal.com]

I had a think about the database, and part of the problem is that the info changes as more people book on So I have info coming in in one spreadsheet, which then that info has to go into another spreadsheet as well (I am working with two different companies who use their own spreadsheets, so I have to use them too). So I would be picking up data from the first one, then putting it into the database, and then on to the other spreadsheet. Plus continuing to pick up address info from a third spreadsheet. Thanks god it's a long weekend. By Fridays my brain starts feeling all 'splodey.