Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Report
-
 shannon -
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,


See more

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
"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
4
Thank you

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

CCM 2942 users have said thank you to us this month

Report

Thank you very much. That works well.
Ask a question