Thanks Max to give your valuable time to answer my question.
I have one other problem also so
I will send U my workbook on your address.
Please solve my problem when U get time.

Thanks to Pete also.
Regards,

"Max" wrote:

Ahh.., now much clearer
- that's the way you should have described it earlier <g

In Sheet2,
Put in B2:
=IF(MOD(COLUMN(A1),2),OFFSET(Sheet1!$E$3,INT((COLU MN(A1)-1)/2),),"")
Copy B2 across to K2 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nad" wrote:
Sorry Max, I did'nt get my result.
Let me explain U again what i want.
I have data In Sheet1 / Column E3..E5
I want to put these data of Sheet1 In Sheet2(from B2..K2) leaving one cell.
In Sheet2
Cell B2 (data from Sheet1/E3)
c2 (Empty)
d2 (Data from Sheet1/E4)
...