Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy template to master spreadsheet
Hi, I am very new at vba.
I have a workbook with two sheets (sheet1 is master sheet and sheet2 is this template in which I send to my clients)and once I get this template back, I copy the data from the template into the master sheet via recorded macro. I would like to copy the data into the master with command button. the range in the template differe so I can't copy row by row into the master. How can I tell the macro to go to the next row in order to transfer new data from another template and so on...? I hope I made this clear...Please let me know if you need further information. Also I can send you a copy of my workbook. I need help desperately. thanks very much in advance. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a master spreadsheet, how do I create a copy? | Excel Worksheet Functions | |||
how to auto "copy & paste" (or filter) from a Master spreadsheet? | Excel Worksheet Functions | |||
HOW DO I SET UP A MASTER TEMPLATE SO IT CAN'T BE CHANGED | Excel Discussion (Misc queries) | |||
Master Workbook used as my template? | New Users to Excel | |||
how can I set up a master template and have the changes copied to. | Excel Worksheet Functions |