if the structure of sheet1 is the same as sheet 2 the copy paste will
work fine.

you shouldn't have any data in columns c and d in sheet 1 because they
are hidden ...........


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469901