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" wrote in message
ps.com...
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?