Why don't you just enter this formula in Sheet2 B2:

=IF(Sheet1!$E$3="","",Sheet1!$E$3)

Then copy this to the other cells where you want the formula to be
(D2, K2 ?) and then just edit them to:

=IF(Sheet1!$E$4="","",Sheet1!$E$4)
and
=IF(Sheet1!$E$5="","",Sheet1!$E$5)

Hope this helps.

Pete

On Apr 3, 9:00 am, 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)
...
Sorry Max, May be i confused U.
Regards



"Max" wrote:
=IF(MOD(ROW(E3),2),Sheet1!$E3,"")

Just replace ROW with COLUMN if you're copying across,
but I'm not sure how you want the "Sheet1!$E3" part to behave

Try out these 3 examples to see which returns what you're really after

=IF(MOD(COLUMN(E3),2),Sheet1!$E3,"")
returns Sheet1!$E3 in the cell, then when copied across will skip alternate
columns, and return only: Sheet1!$E3 since the $ fixes it to col E

while:
=IF(MOD(COLUMN(E3),2),Sheet1!E3,"")
returns Sheet1!E3 in the cell, then when copied across will skip alternate
columns and increment: Sheet1!E3 "horizontally" to return: Sheet1!G3, then:
Sheet1!I3, etc

and .. this variation:
=IF(MOD(COLUMN(E3),2),OFFSET(Sheet1!$E3,COLUMN(A1)-1,),"")
returns Sheet1!E3 in the cell, then when copied across will skip alternate
columns and increment: Sheet1!E3 "vertically" to return: Sheet1!E5, then:
Sheet1!E7, etc

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nad" wrote:
Very Thanks Max, U are realy Max........imum.
This is realy what i want.
But i still have a problem.
This formula is working when i copy it to downward but when i copied it to
the right of the cell it is not working.
My formula is =IF(MOD(ROW(E3),2),Sheet1!$E3,"")- Hide quoted text -

- Show quoted text -