Hi Nad,

Try turning on the Macro recorder while you perform the
requisite actions manually.

The resultant code may be edited in order to optimise it
and obtain a more generic procedure.

If you experience problems with such editing, post your
code and indicate the specific problems.


---
Regards,
Norman


"Nad" wrote in message
...
Hi,
Please help to write the Macro.
In Sheet1, i have to copy the range B2..B10
In Sheet2, i want to paste this copied this range like
C4 (Data from Sheet1/B2)
D4 (Blank)
E4 (Data from sheet1/B3)
Now,
C5 (data from Sheet1/B4)
D5 (Blank)
......
Best Regards,