Hi Hernan

There is a example on this page
http://www.rondebruin.nl/copy5.htm

Try
http://www.rondebruin.nl/copy5.htm#one

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Hernan" wrote in message
...
Hello,

I have this sheet that has 5 columns. The fifth one is named "Status" and
it
can either be "IN" or "OUT".

I would like to move all the rows which status column is OUT to sheet 2,
and
without leaving blank rows in sheet 1.

Any help is always appreciated.

TIA

Hernan

Hi Hernan

The code do what you want

It filter a column and copy the result to a new sheet and delete the records you copy

Have you try it in a test workbook ?
http://www.rondebruin.nl/copy5.htm#one

Read the info in the code
You can use the comented code if you want to delete the records you copy to the new sheet



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hernan" wrote in message ...
Thank you for your help.

Although I cannot believe I asked the way I did.

What I am wanting to do is to:

while
status column in sheet 1=out then
select row
cut row
paste row into sheet 2 in next blank row
delete blank row in sheet 1
wend

Any help provided for me to understand this, is greatly appreciated.

TIA.

Hernan


"Ron de Bruin" wrote:

Hi Hernan

There is a example on this page
http://www.rondebruin.nl/copy5.htm

Try
http://www.rondebruin.nl/copy5.htm#one

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Hernan" wrote in message
...
Hello,

I have this sheet that has 5 columns. The fifth one is named "Status" and
it
can either be "IN" or "OUT".

I would like to move all the rows which status column is OUT to sheet 2,
and
without leaving blank rows in sheet 1.

Any help is always appreciated.

TIA

Hernan