Copy a variable number of rows

[aldenes]

Hi,
I am trying to write a VBA script to copy a variable number of rows from top to bottom from sheet1 in sheet2; the number of rows copied, equal to the value of cell C2 (highlighted in yellow) in sheet2
For example if C2=2, copy 2 rows, C2=3, copy 3 rows, etc
Any help would be greatly appreciated.

[BadlySpelledBuoy]

Not enough information provided. Do you want the header row from Sheet1 copied over? Does it count as 1 of the rows? i.e. C2=2 then data copied = header row + 1 row of data? WHERE on Sheet2 do you want it copied to? When the number in C2 changes do you want the previously copied data deleted/ovewritten or appended to with the next set?

Might be an idea to show us your desired result in a couple of scenarios.

BSB

[aldenes]

Sorry for not providing all the info.
Header from sheet 1 does not need to be copied over
Data rows that need to be copied start below the header; they will be copied starting with row 3 in sheet2; every time the script runs (with a new C2 value), it would copy rows by appending to the last row
Thank you so much for your willingness to help me resolve my problem!

[BadlySpelledBuoy]

Right click the tab for Sheet2 and select "View Code". Paste the code below into thet Sheet2 module then close the VB Editor.
Changing the number in C2 (so long as it's greater than zero) will move that number of rows from Sheet1 to Sheet2.

Please Login or Register  to view this content.

Is that what you mean?

BSB

[aldenes]

That's awesome and that's exactly what I mean. One more question though...
I want to write this code as part of a sub to add as part of a macro. The way is written does not work for a macro; I think the variable needs to be defined in a different way?
Thanks you so much for your help!

[BadlySpelledBuoy]

Maybe this?

Please Login or Register  to view this content.

BSB