Copy paste macro

Closed
venkat833 - Apr 23, 2010 at 06:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:40 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 23, 2010 at 12:40 PM
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
0