copy a group to a new worksheet

[dazil]

Hi, Sorry if this is an stupid question and a bit long to explain but
have tried to find the answer for two days now.

I have a worksheet with for example the
A1 oranges
A2 oranges
A3 apples
A4 apples
A5 apples
A6 grapes

what I need is a the group of oranges to be copied into its ow
worksheet and the same for the group of apples.

I have the data grouped but have no way of telling how many orange
will be in a group or apples etc. I'm looking for somthing that wil
look at A1 and create a worksheet called oranges then copy all th
cells containing oranges into the new worksheet, when the macro detect
a change to apples or grapes create a new worksheet called apples o
grapes and copy the cells again until it finds an empty cell and end
the routine

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy5.htm

 

[dazil]

Thanks, Ron de Bruin.

I got your code working straight out of the box.

I cant ask for any more help than that.