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

M

Michael B

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.
 

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

Using VBA to copy data into another worksheet ??? 2
Macro to merge workbooks onto one worksheet 1
Create if partial match then copy and paste data from one cell to another 1
Copying web pages onto Excel Spreadsheets using VBA 5
Copy filtered data to sheet 2 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Find last row in workbook sheet & move data to it from another sh 5
copying to new workbook 0

Top