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

shannon - Feb 28, 2012 at 03:09 PM - Latest reply:  shannon
- Feb 29, 2012 at 09:27 AM
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.

See more 

2 replies

Best answer
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Feb 28, 2012 at 10:52 PM
Thank you
"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, venkat1926 4

Something to say? Add comment

CCM has helped 1720 users this month

Thank you very much. That works well.