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

You can filter and copy to a new sheet

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


--

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


"F.G." wrote in message ...
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

On Jan 14, 12:57*pm, "Ron de Bruin" wrote:
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