Pete, Thanks for responding.

IF duplicates - yes add the data together.

i have approximately 7 columns and approximately 16,804 rows.

The sheets are in different workbooks. I can put them into one if it
helps.

thanks again.

Pat


--
orthomedus
------------------------------------------------------------------------
orthomedus's Profile: http://www.excelforum.com/member.php...o&userid=32641
View this thread: http://www.excelforum.com/showthread...hreadid=524481