Data in a seperate worksheet

[F.G.]

Hi,

I have excel workbook containing information:

Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2
CSA 3 Name 3
CPO Name 4

How can I create separate sheets for titles without having spaces
between rows
For example the worksheet for CPO-s would look like:

Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2
CPO 1 Name 4

Instead of:
Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2

CPO Name 4

I would appreciate your help.

Thank You
FG

 

[Ron de Bruin]

You can filter and copy to a new sheet

See the code example on this page
http://www.rondebruin.nl/copy5.htm#sheet

 

[F.G.]

You can filter and copy to a new sheet

See the code example on this pagehttp://www.rondebruin.nl/copy5.htm#sheet

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm


- Show quoted text -

Dude You are genius.
I would have not found the solution without your help.
Thanks a lot.

Regards,
FG