0
Thanks

A few words of thanks would be greatly appreciated.

Excel-VBA - Copy/paste cells then move to next row




Issue


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.

Solution


"Copy it to the row below the previous collected data. "
  • After copy statement:
  • Worksheets(destination sheet name within doublequotes).cells(rows.count,"A").end(xlup).offset(1,0).pastespecial


Thanks to Venkat1926 for this tip.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on by aakai1056.

This document, titled "Excel-VBA - Copy/paste cells then move to next row," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).

0 Comments