Hi, friendly Excel Gurus...
I have two very large data sets that I need to merge. One contains approx. 10,000 ID numbers in Column A, with multiple columns of data for each. The second contains a subset of these ID numbers, and one column of useful data. I need to tack this one column of data onto the other spreadsheet such that the ID numbers remain associated with the correct data. That is, I can't just cut and paste the column into the larger spreadsheet, as the ID numbers are not in the same order, and there isn't an entry in the second sheet for every ID number in the first sheet. Accurately cross-referencing the data to the IDs is absolutely critical, but not feasible by hand for a set this large!
I hope I've explained this clearly... I am fairly new to VBA, but a quick learner, so I thank you in advance for your time (and patience)!
Amy
I have two very large data sets that I need to merge. One contains approx. 10,000 ID numbers in Column A, with multiple columns of data for each. The second contains a subset of these ID numbers, and one column of useful data. I need to tack this one column of data onto the other spreadsheet such that the ID numbers remain associated with the correct data. That is, I can't just cut and paste the column into the larger spreadsheet, as the ID numbers are not in the same order, and there isn't an entry in the second sheet for every ID number in the first sheet. Accurately cross-referencing the data to the IDs is absolutely critical, but not feasible by hand for a set this large!
I hope I've explained this clearly... I am fairly new to VBA, but a quick learner, so I thank you in advance for your time (and patience)!
Amy