Merge two Excel 2000 spreadsheets
 

I have an inventory spreadsheet with three pages. Is there a way to
merge two copies of the spreadsheet such that the resulting spreadsheet
will have the sum all of the inventory totals in both copies without
changing anything else?

For example:

Spreadsheet 1:
1234 Item1 250 2345 Item2 39
3456 Item3 900 4567 Item4 22

Spreadsheet 2:
1234 Item1 75 2345 Item2 27
3456 Item3 450 4567 Item4 13

Merged Spreadsheet:
1234 Item1 325 2345 Item2 66
3456 Item3 1350 4567 Item4 35

Thanks for your time.

Hi
are the item names on all sheets always in the same position?

--
Regards
Frank Kabel
Frankfurt, Germany
"Marikallees" schrieb im Newsbeitrag
ups.com...
I have an inventory spreadsheet with three pages. Is there a way to
merge two copies of the spreadsheet such that the resulting spreadsheet
will have the sum all of the inventory totals in both copies without
changing anything else?

For example:

Spreadsheet 1:
1234 Item1 250 2345 Item2 39
3456 Item3 900 4567 Item4 22

Spreadsheet 2:
1234 Item1 75 2345 Item2 27
3456 Item3 450 4567 Item4 13

Merged Spreadsheet:
1234 Item1 325 2345 Item2 66
3456 Item3 1350 4567 Item4 35

Thanks for your time.

Yes. The product codes are in columns A and E, the item names are in
columns B and F, and the inventories are in columns C and G. This holds
true for all three sheets.

Hi
the on your summary sheet use the following for example in C1
=SUMIF('sheet1'!A:A,A1,'sheet1'!B:B)+SUMIF('sheet2 '!A:A,A1,'sheet2'!B:B)

--
Regards
Frank Kabel
Frankfurt, Germany
"Marikallees" schrieb im Newsbeitrag
ups.com...
Yes. The product codes are in columns A and E, the item names are in
columns B and F, and the inventories are in columns C and G. This holds
true for all three sheets.

I'm not very experienced with Excel, how would I go about setting up
this summary sheet and running the formula? Do you have any reference
links that might help me to understand how to do this?

Hi
you should start with entering the product ID's and names on your summary
sheet. Then apply this formula on this summary sheet

--
Regards
Frank Kabel
Frankfurt, Germany
"Marikallees" schrieb im Newsbeitrag
oups.com...
I'm not very experienced with Excel, how would I go about setting up
this summary sheet and running the formula? Do you have any reference
links that might help me to understand how to do this?

Unless I'm missing something, that's way to involved for my users to
handle. It would be faster and easier to hand-type the totals than to
ask relatively computer illiterate people to run that formula. :(

Hi
but then you risk that they 'handtype' wrong totals.

--
Regards
Frank Kabel
Frankfurt, Germany
"Marikallees" schrieb im Newsbeitrag
oups.com...
Unless I'm missing something, that's way to involved for my users to
handle. It would be faster and easier to hand-type the totals than to
ask relatively computer illiterate people to run that formula. :(