combining data from multiple worksheets

  • Thread starter Thread starter Taylor
  • Start date Start date
T

Taylor

I want to have a master sheet with data from several other worksheets. Each
worksheet has a few columns that have the same header (ie Customer, Style) as
well as a few unique columns. I want to have a master list for the similar
columns (customer, style) with all possibilities and fill in the data from
the individual sheets. How can I get the unique columns to be added to the
master sheet and match to the correct customer?

Any help would be appreciated!

Thanks,

Taylor
 
Hi,

If the data you want to combine is numeric, you might look at the command
Data, Consolidate. You can use the option User labels in Top Row to help
solve your problem.
 
Thanks, Shane. The data is not numeric, but I used the VLOOKUP function,
which worked well. Thanks for the advice.

Taylor
 
Back
Top