VBA copy/paste cells then drop 1 row for next
Solved/Closed
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,
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:
- VBA copy/paste cells then drop 1 row for next
- Tentacle locker 1 - Download - Adult games
- Igi 1 download for pc - Download - Shooters
- Fnaf 1 download pc - Download - Horror
- Fnia 1 apk - Download - Adult games
- Poppy playtime chapter 1 download pc - Download - Horror
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 28, 2012 at 10:52 PM
Feb 28, 2012 at 10:52 PM
"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
use something lke this
after copy statement
worksheets(destination sheet name within double quotes).cells(rows.count,"A").end(xlup).offset(1,0).pastespecial
Feb 29, 2012 at 09:27 AM