[Excel-VBA] Copy/paste cells then move to next row
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.
"Copy it to the row below the previous collected data. "
Thanks to Venkat1926
for this tip.