Previous Topic Next Topic

VBA copy/paste cells then drop 1 row for next

Solved/Closed
shannon - 28 Feb 2012 à 15:09
 shannon - 29 Feb 2012 à 09:27
Hello,
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.
Thanks,


Related:

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
28 Feb 2012 à 22:52
"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
shannon
29 Feb 2012 à 09:27
Thank you very much. That works well.

Similar discussions

Can no longer paste text into insta
6hypnone -
Gordon -

7 responses