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 |
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 |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com