copy a group to a new worksheet

D

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
 
D

dazil

Thanks, Ron de Bruin.

I got your code working straight out of the box.

I cant ask for any more help than that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Next Largest Number Based on Criteria 3
Macro to add numbers in a text string 5
Group items 3
Move data from on sheet to another keep duplicate rows 4
Copy new data to worksheet 11
Remove spaces between items in a dropdown list 1
Copy range from one open workbook's worksheet to another. 4
Combine, sort, & then create worksheet 1

Top