Copy paste macro [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello all ,

I need a small help in doing macro.

can you please any one help me ?

for example:-

In sheet1 i have data from A1 to A4( this data will change every time) i want to copy from sheet1 to and paste in sheet2 (i want to paste first time in sheet2-A1 and second time in sheet2 -A2----its go on like this )
In sheet2 i want to run macro.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Have your tried to record you marco. Record a macro and paste the code if you need to make it generic

remember
lastrow = cells(rows.count, "A"),end(xlup).row will give u last used row in column a

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!