I have create a macro that does
1. create 3 sheet, named: C1, C2 & C3
2. Select the fruit column,AutoFilter
3. Choose €œApple€� which is the first on the list; select the sheet; and then
copy the sheet to the C1
3. Choose €œGrape€� which is the second item on the list; select the sheet and
then copy the sheet to the C2
4. Choose €œWatermelon€� which is the second item on the list; select the
sheet and then copy the sheet to the C3

My question is how do I change my marco so it will pick up any fruit (e.g.
Banana, Pear, Watermelon), what ever it is on the list and excute the steps
according.

Any suggestion?

--
Aline