Previous Topic Next Topic

Copy a range of cell x number of times

Closed
Jai - Dec 27, 2016 at 08:55 PM
 Blocked Profile - Dec 27, 2016 at 10:35 PM
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 response

Answer 1 / 1
Blocked Profile
Dec 27, 2016 at 10:35 PM
I am confused, your range is reference as E1:F1, why not call it THERANGE, then paste THERANGE into A1?

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
range of numbers
whatsit -
Mazzaropi -

3 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses