Copying Data List to Different Worksheet
 

I have created a simple list, which allows my worksheet to 'grow' as
more items are entered (new rows are added which push the rest of the
existing rows down). I need to automatically copy whatever is entered
in the list to another worksheet. My tests fail- when I enter multiple
items on the list, only the first entry copies to the other sheet. Any
ideas? Thanks.


--
rhovey
------------------------------------------------------------------------
rhovey's Profile: http://www.excelforum.com/member.php...o&userid=32308
View this thread: http://www.excelforum.com/showthread...hreadid=523090