Correctly copy cells with a macro
 

I have a form that after it is filled out I would like to transfer the
information (with a macro button) into an ongoing list on another page. Can I
program a macro to paste the information on the worksheets next available
line since this number will change everytime I use it as the list grows
larger with every entry?

Hi Amy

See this page
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Amy" wrote in message ...
I have a form that after it is filled out I would like to transfer the
information (with a macro button) into an ongoing list on another page. Can I
program a macro to paste the information on the worksheets next available
line since this number will change everytime I use it as the list grows
larger with every entry?

Ron,
What a lifesaver you are! Thank you for your quick response to a problem
that has been driving me batty for a few hours:)
Many, Many THANKS!!!

"Ron de Bruin" wrote:

Hi Amy

See this page
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Amy" wrote in message ...
I have a form that after it is filled out I would like to transfer the
information (with a macro button) into an ongoing list on another page. Can I
program a macro to paste the information on the worksheets next available
line since this number will change everytime I use it as the list grows
larger with every entry?

You are welcome

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Amy" wrote in message ...
Ron,
What a lifesaver you are! Thank you for your quick response to a problem
that has been driving me batty for a few hours:)
Many, Many THANKS!!!

"Ron de Bruin" wrote:

Hi Amy

See this page
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Amy" wrote in message ...
I have a form that after it is filled out I would like to transfer the
information (with a macro button) into an ongoing list on another page. Can I
program a macro to paste the information on the worksheets next available
line since this number will change everytime I use it as the list grows
larger with every entry?