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.
--
Arturo