Hi All,
What i am trying to accomplish is to copy a range, say "D7:D9" and paste it into another worksheet, with one cell in between horizontally and one cell in between vertically.
For example, cell D7 would be copied into D7 on a different worksheet.
Cell D8 would be copied into D10 on a new worksheet,
cell D9 into D12,
and horizontally,
D7 into D7 on a new worksheet,
E7 into G7 on a new worksheet,
F7 into J7.
Could anyone please help me out how to write such code.
Thank you
What i am trying to accomplish is to copy a range, say "D7:D9" and paste it into another worksheet, with one cell in between horizontally and one cell in between vertically.
For example, cell D7 would be copied into D7 on a different worksheet.
Cell D8 would be copied into D10 on a new worksheet,
cell D9 into D12,
and horizontally,
D7 into D7 on a new worksheet,
E7 into G7 on a new worksheet,
F7 into J7.
Could anyone please help me out how to write such code.
Thank you