Hi Gazza

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gazza" schreef in bericht ...
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