merging spreadsheets

  • Thread starter Thread starter childofthe1980s
  • Start date Start date
C

childofthe1980s

Hello:

I have two spreadsheets with similar data. Each has four columns. A = Item
Number, B = Location (each row has the phrase "CH"), C = Quantity, and D =
Number of Days (each row has the number "10").

Each of the two spreadsheets has some of the same items in column A. So, I
want to merge the spreadsheets into one, add the quantities for column C, and
eliminate the duplicates for column A.

Is there a way to do this without extensive programming (i.e. just using
"Sort" and other menu selections)?

Thanks!

childofthe1980s
 
Join your 2 list togeter. With "Pivot table" you can get a list of unique
value. Then VLookup the other column ( B,C & D) in the list obtained with the
pivot table.
 
Back
Top