I have not tried this, but I am assuming it works and great! :-)

However, what I am looking for is to do this automagically, so most likely
this will have to be done with VBA.

Sorry for my late response, you guys are great!

Thanks for the great help.

Hernan.

"Teethless mama" wrote:

If you do not want any blank cells in between, then try this:

In Sheet 2
A1
=IF(ISERR(SMALL(IF(Sheet1!$E$1:$E$7="Out",ROW(INDI RECT("1:"&ROWS(Sheet1!$A$1:$A$7)))),ROWS($1:1)))," ",INDEX(Sheet1!$A$1:$A$7,SMALL(IF(Sheet1!$E$1:$E$7 ="Out",ROW(INDIRECT("1:"&ROWS(Sheet1!$A$1:$A$7)))) ,ROWS($1:1))))

Adjust your range to suit
ctrl+shift+enter (not just enter)
copy down as far as need


"Hernan" wrote:

Hello,

The sheet I have has 5 columns and the 5th is for status, IN or OUT.

What I want is to MOVE the row to another worksheet in the same workbook IF
the status is OUT.

TIA

Hernan