Save filtered data as a separate file

G

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
 

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

Top