A Macro to Copy Rows by Value Cho

Closed
Goldenpetals - Jun 21, 2016 at 08:11 PM
Hello,

I would like to know if we can write a macro to copy a specific number of rows, which will be 24, 32 or 48.

These values will be included on a validation drop-down.

Also, I would like the user to choose the number of times this specific range is copied. I would like for them to have a range between 1-24.

EXAMPLE:

Drop-down 1:

24
32
48

(Also, a blank row to separate the groups)

Drop-down 2:
1
2
3
4
etc.

Then a command button to execute the macro.

Example:
The user will choose 24 from drop-down 1.
Then user will choose 5 from drop-down 2.

When the user clicks the command button they will have a total of 5 groups of datasets consisting of 24 rows. All separated by a blank line.

Also, each row must have the needed formulas that will need to exist in each row.

Hope someone can assist please.

Thank you for your time.

Goldenpetals