PC Review


Reply
Thread Tools Rate Thread

Copy data onto new workbook and move onto next lot of data

 
 
Michael B
Guest
Posts: n/a
 
      4th Dec 2007
Hi,
Help! I have very little experience with macros.
I have a questionairre with 5 options to each question, when the option is
clicked, the results save onto sheet 2. I need to create a button that will:

At the end of the questionairre, copy the results from sheet2 to another
workbook called "Pulse check" onto a worksheet called "Jamie" onto the next
available line so the previous data is not overwritten.
I also need the button to move onto the next available line on Sheet2 so the
original data is not overwritten when the next questionairre is done and then
to reset the option buttons ready for the next person to complete the
questionairre.

I would appreciate any help.

Thanks

Michael.
 
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
Copy data from Workbook Alpha & reorganize it in Workbook Bravo u473 Microsoft Excel Programming 1 31st Oct 2007 02:37 AM
Move data within workbook =?Utf-8?B?Z3JlZ2F0dnJt?= Microsoft Excel Misc 2 27th Aug 2007 06:50 PM
automatically move cell data in 1 workbook to another workbook =?Utf-8?B?R2VuZXNpcw==?= Microsoft Excel Worksheet Functions 1 5th Nov 2006 07:35 PM
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. Cristobalitotom Microsoft Excel Programming 0 6th Jul 2006 12:24 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook burl_rfc Microsoft Excel Programming 1 1st Apr 2006 08:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:07 AM.