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

--
dazi
-----------------------------------------------------------------------
dazil's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56954