in cell A1 of sheet 2 enter the formula

=if(sheet1!a1="","",sheet1!a1)

then copy this to however many rows and columns you want.

then as you add data on sheet 1, it will appear on sheet 2


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=565085