Excel: Comparing multiple sheets to a master

Dell Dell xps m1210 notebook computer in...
June 7, 2010 at 07:47:23
Specs: Windows Vista
I have a workbook that has 11 sheets. The first is an asset list of 6000 items with serial numbers (master list). Each other sheet has a few serial numbers and extra information. All the master list is not listed in the seperate sheets so i need to compare all 10 sheets to the master list and if the serial numbers match the master list transfer all the data to the master list next to the corresponding serial number.... Thanks

See More: Excel: Comparing multiple sheets to a master

Report •

June 7, 2010 at 14:09:42
I'm a tad confused.

Are you saying that the master list is missing some of serial numbers that can be found on the other 10 sheets or that all of the numbers are there but the data is not?

In any case, before we could offer any specific code, you'll need to provide some details, such as the layout of the sheets.

e.g. What column are the serial numbers in? Is it the same on every sheet, including the master? Does transfer the data mean copy the entire row or a specific range.

The more detail you provide about the layout of the sheet, the easier it is for us to provide a solution.

Report •
Related Solutions

Ask Question