Copy a range of cell x number of times [Closed]

Report
-
 Blocked Profile -
Hello,
Friend my query is

I want to copy value from range (E1:F1)
Base on the value from G1
And paste on range from A1&B1. It should continue copy and paste to the next row of A & B
Meaning it should append to last row used
Here I want to use command button so that when I click on the macro execute.

Please help me out.

1 reply


I am confused, your range is reference as E1:F1, why not call it THERANGE, then paste THERANGE into A1?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!