merging spreadsheets

  • Thread starter childofthe1980s
  • 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
 
Y

Yanick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Merging from an Excel file with graphics 1
Mail Merge Help 1
MS Project Import Error Row 1 Column 5 2
Identifying duplicates between 2 spreadsheets 0
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Enable Iterative Calculations 0
merging two large spreadsheets 2

Top