Save filtered data as a separate file

[Gazza]

Looking for help in constructing a proceedure that will filter data in a
table based on a given criteria and save just this data as a separate file

Apples 10
Pears 20
Apples 30
Pears 25
Plums 15
Plums 20

It will filter the list as apples and save a file of just apples data.
Then it will filter the list as Pears and save a file of just pears data
etc..

(The actual file is much bigger than this with more data)

Thanks in advance

 

[Ron de Bruin]

Hi Gazza

Try the workbook example on this page
http://www.rondebruin.nl/copy5.htm