Macro, AutoFilter...
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
|