peter_act
05-27-2009, 08:29 PM
Hello,
A simple task for you, hard for me:
I want to go to a cell (say I6)
Highlight cells I6:W6
Copy these cells
Scroll down 25 rows to cell I31
Highlight cells I31:W31
Paste
Now Highlight cells I31:W31
Copy these cells
Scroll down 25 rows to cell I56
Highlight cells I56:W56
Paste
Repeat 50 times, each time copying the last range of cells you pasted to a range 25 rows beneath it
I've only done it twice in the example above, just to give an example of what I want to do, but I have a 15000 row worksheet and I need a macro.
I've tried "record new macro" but it keeps running the macro and then going back to my original starting point (Cell I6) instead of the last cell I pasted to.
Hope you can understand this
peter_act
A simple task for you, hard for me:
I want to go to a cell (say I6)
Highlight cells I6:W6
Copy these cells
Scroll down 25 rows to cell I31
Highlight cells I31:W31
Paste
Now Highlight cells I31:W31
Copy these cells
Scroll down 25 rows to cell I56
Highlight cells I56:W56
Paste
Repeat 50 times, each time copying the last range of cells you pasted to a range 25 rows beneath it
I've only done it twice in the example above, just to give an example of what I want to do, but I have a 15000 row worksheet and I need a macro.
I've tried "record new macro" but it keeps running the macro and then going back to my original starting point (Cell I6) instead of the last cell I pasted to.
Hope you can understand this
peter_act