PC Review


Reply
Thread Tools Rate Thread

copy template to master spreadsheet

 
 
Reza K
Guest
Posts: n/a
 
      18th Feb 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PPT 2007 Theme Master Trumps Template Master NY Law Firm Trainer Microsoft Powerpoint 5 2nd Jun 2009 10:36 PM
How an I copy spreadsheet info onto a template? beverly Microsoft Word Document Management 1 4th Dec 2007 12:45 PM
I have a master spreadsheet, how do I create a copy? =?Utf-8?B?a2F0?= Microsoft Excel Worksheet Functions 2 29th Oct 2006 08:21 AM
how to auto "copy & paste" (or filter) from a Master spreadsheet? =?Utf-8?B?QXJtYW5kbw==?= Microsoft Excel Worksheet Functions 0 13th Sep 2006 08:55 PM
Adding new design template to a New slide master/title master =?Utf-8?B?S2F5ZQ==?= Microsoft Powerpoint 3 17th Mar 2006 02:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:57 PM.