Advanced filter-can this be done?

[SGT Buckeye]

I have a master worksheet that has 7 columns of data: name, platoon,
APFT badge, certificate, score, go/no-go, date. In the second column
there are five possible entries: 1, 2, 3, OPS, HQ. I would like to
use the advanced filter to filter data by platoon and place it into
seperate sheets for each platoon. I am familiar with basic advanced
filtering but when I updated the criteria for the filter to send 2nd
platoon's data, I lost 1st platoon's. How can I get around this
problem? And how can I get it to run the filter automatically as I
enter data on the master worksheet?

 

[Bob Phillips]

What do you mean by 'lost'?

Are you doing this manually or by code? If the latter, post the code.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

You may find some tips here:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb