A
Arturo
I have 2 worksheets, same workbook, with similar information and wish on a
3rd worksheet to add the like items together and also display the unlike
items.
EXAMPLE:
SHEET 1 SHEET 2
A B C A B C
1 ITEM QTY AMT ITEM QTY AMT
2 2x4x8 8 $24.00 4X4X8 2 $16.00
3 4x4x8 10 $80.00 2x6x8 10 $50.00
4 2X10X8 2 $24.00
Note that not all products are listed on each sheet and the order will
change monthly. Thank you.
3rd worksheet to add the like items together and also display the unlike
items.
EXAMPLE:
SHEET 1 SHEET 2
A B C A B C
1 ITEM QTY AMT ITEM QTY AMT
2 2x4x8 8 $24.00 4X4X8 2 $16.00
3 4x4x8 10 $80.00 2x6x8 10 $50.00
4 2X10X8 2 $24.00
Note that not all products are listed on each sheet and the order will
change monthly. Thank you.