wow...another great answer...

thanks

"Jacob Skaria" wrote:

A formula solution would do. Is it ColC or ColB which is empty

If it is col C; try the below formula in Sheet2 cell A1 and drag/copy across
upto D1. Once done you can select A1:D1 copy/drag the formula down as required

=IF(COUNTA(Sheet1!$C$1:$C$1000)<ROW(A1),"",INDEX(S heet1!A$1:A$1000,SMALL(IF(Sheet1!$C$1:$C$1000<"", ROW($A$1:$A$1000)),ROW(A1))))

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"


If it is Col B which is blank use the below instead..
=IF(COUNTA(Sheet1!$B$1:$B$1000)<ROW(A1),"",INDEX(S heet1!A$1:A$1000,SMALL(IF(Sheet1!$B$1:$B$1000<"", ROW($A$1:$A$1000)),ROW(A1))))


If this post helps click Yes
---------------
Jacob Skaria


"reza" wrote:

HI all....

i want to move data from sheet1 to another sheet, maybe it will need
macro...hope you can help me. Example...in sheet1 i have:
Line Col A Col B Col C Col D
AA 10 5 4 1
BB 5 - - -
FF 13 3 2 2
KK 10 - - -

now in sheet2 i want to create resume from sheet1 automatically....
but i want if col B is empty or no data...it can't move to sheet2...
so and in sheet2
Line Col A Col B Col C Col D
AA 10 5 4 1
FF 13 3 2 2


thanks in advance

reza