copy template to master spreadsheet

R

Reza K

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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Macro to Compile Data from Different Sheets 2
Copy range from multiple files in multiple folders to single sheet in master WB 10
Macro to Combine Data from Multiple Sheets with Cell References 4
linking sheets and workbooks 0
Delete duplicate rows without deleting entire row 1
Excel Template Question... 2
Save record Into master sheet! 1

Top