Copy paste macro

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