| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save filtered data as a separate file
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save filtered data as a separate file
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save a page in a workbook as a separate file? | Excel Worksheet Functions | |||
| How do I save part of a worksheet in a separate file? | Excel Worksheet Functions | |||
| Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
| Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
| How to save each sheet as a separate excel-file | Excel Programming | |||
Linear Mode
