Ahh - and there's the rub. I should have explained better. One worksheet
does not have hidden columns.

"bill k" wrote:


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