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?

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)



"SGT Buckeye" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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?
>

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

SGT Buckeye wrote:
>
> 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?

--

Dave Peterson