Need to combine multiple Excel sheets

[davidg47]

Hi,

I have 2 seperate Excel 2003 spreadsheets that I need to combine into one. In one spreadsheet there are about 50,000 employee records with misc. info on both current and non-current employees. In another spreadsheet I have a list of all the stores and the supervisor names with contact information for the store and the supervisor. There is one common column between the two sheets. In the employee sheet, it is named "Salon# and in the second sheet it is named "Location2". Now multiple records from the employee sheet will have the same Salon#, and of course the second sheet is only a list of all the store locations with contact information. How can get the store and supervisor information to match up to the employee information and have that information (imported?) into the employee sheet?

 

[arthurbr]

Maybe you would be better considering using MSAccess for this kind of huge job.
Depending on your machine a VLOOKUP would be very long and would likely freeze XL.
Good luck

André

 

[davidg47]

OK, good point. So how would I go about doing this from within Access 2003?

 

[SkipVought]

Hi,

Take a look at MS Query using Data/Get External Data/New Database Query -- Excel Files -- YOUR WORKBOOK ...

You can use the QBE grid to JOIN the two tables, assuming that you have your data structured in accordance with List & Table rules.

Your query can use criterions to return ONLY the data that you are interested in. It has lots of flexibility.

Skip,

_[red][/red]