Hi all,
I have a question regarding VBA I need to use.
Can you please help.
The macro needs to do the follwing:
1. Go to sheet 1
2. Clear cells A2 to Z2
3. Go sheet 2
4. Copy cells A2 to Z2
5. Go to sheet 1
6. Paste the cells to the range A2 to Z2
7. Loop throguh points 1 to 6 to the last row in the sheet 2
Of course it will have some more things to do after point 6 but I can manage it myself, anybodey can help ?
I have a question regarding VBA I need to use.
Can you please help.
The macro needs to do the follwing:
1. Go to sheet 1
2. Clear cells A2 to Z2
3. Go sheet 2
4. Copy cells A2 to Z2
5. Go to sheet 1
6. Paste the cells to the range A2 to Z2
7. Loop throguh points 1 to 6 to the last row in the sheet 2
Of course it will have some more things to do after point 6 but I can manage it myself, anybodey can help ?