I want to enter data on one worksheet - one record at a time and transfer it
to a list on another worksheet so that it adds each new record to the bottom
of the list on the second. Appending the entries made on the first (which
only ever holds the latest entry) to the list which increases with each
addition on the 2nd worksheet.
I have done this before by writing some VBasic code but cant remember how to
do it!
Can anyone help

Will this work for you?
http://www.rondebruin.nl/copy1.htm

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mia-N" wrote:

I want to enter data on one worksheet - one record at a time and transfer it
to a list on another worksheet so that it adds each new record to the bottom
of the list on the second. Appending the entries made on the first (which
only ever holds the latest entry) to the list which increases with each
addition on the 2nd worksheet.
I have done this before by writing some VBasic code but cant remember how to
do it!
Can anyone help