On a daily basis I have to generate several workbooks that end up with
duplicate rows. I need to combine the duplicate part numbers and add the QTYS
keeping everything else intact. Can someone please help me. I have been
manualy updating these for a few days and it take hours as they have up to
250 rows each.

Part# MATERIAL RT# Item QTYS
70M0293 10GA HR 46287 F-WBOOM 2
70M0293 10GA HR 46287 F-WBOOM 2
D6M0104 7GA HR A572 46332 WB BOOM 3
D6M0104 7GA HR A572 46332 WB BOOM 3

--
TimP