merging spreadsheets
 

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

merging spreadsheets
 

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.

--
Yanick


"childofthe1980s" wrote:

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

merging spreadsheets
 

I'm still not clear....could you please give some steps?

"Yanick" wrote:

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.

--
Yanick


"childofthe1980s" wrote:

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