Thread: Moving data from one sheet to another.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Moving data from one sheet to another.
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

Reply With QuoteReply With Quote