VBA copy/paste cells then drop 1 row for next

Question

VBA copy/paste cells then drop 1 row for next

[Solved/Closed]

Report

shannon - Feb 28, 2012 at 03:09 PM
shannon - Feb 29, 2012 at 09:27 AM

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,

VBA copy/paste cells then drop 1 row for next
MACRO to copy / paste cell text down various rows ✓ - Forum - Excel
Vba first empty cell in row - How-To - Excel
Copy and paste loop in vba based on cell values ✓ - Forum - Excel
Paste data to next empty row vba - How-To - Excel
A macro to copy/paste a cell and other cells in the same row ✓ - Forum - Excel

1 reply

Ask a question

venkat1926 · Accepted Answer · 2012-02-28T22:52:08-0500

Answer 1 / 1

venkat1926

Posts: 1864
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: August 7, 2021

802
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

Report

shannon
Feb 29, 2012 at 09:27 AM

Thank you very much. That works well.

VBA copy/paste cells then drop 1 row for next

1 reply

Your reply

Subscribe To Our Newsletter!