| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
| Macro to copy value in empty cells | Excel Discussion (Misc queries) | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| macro to copy columns to sheet | Excel Discussion (Misc queries) | |||
| Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
Linear Mode
