VBA copy/paste cells then drop 1 row for next [Solved/Closed]

 shannon -
I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero then fill out the questionaire again. I want the next set of data to go into the row below the previous set of collected data. I can copy the range to another worksheet and reset the answers but I do not know how to take the second set of data and copy it to the row below the previous collected data.

1 reply

Registration date
Sunday June 14, 2009
Last seen
July 30, 2015
"copy it to the row below the previous collected data. "

use something lke this

after copy statement

worksheets(destination sheet name within double quotes).cells(rows.count,"A").end(xlup).offset(1,0).pastespecial
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you very much. That works well.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!