Filter data to other sheets

Hello again. I am in over my head on this one. I can see that there are several options to solve this problem, however, which is the best one? I’d settle for any clue to point me in the right direction. I have a workbook with 8 sheets. One is the actual work area (named WORKAREA), where all my data is accumulated. One is named ACTIVE, where I plan to have a cleaned up version of the WORKAREA sheet. Another is called HISTORICAL; I plan to use it as an archive. Three are the divisions, IDIV, XDIV, and ADMIN, in which I must send filtered data to. That leaves SUMMARY sheet which simple formulas are used to display current manning. Finally, there is DELINQUENT, which I will use to send line data as a report for those personnel that have not completed before the timeline. I have set up a field in my WORKAREA to hold a unique code for each division. I would like to send each corresponding line of data to the appropriate division. Is it possible to set this up so the data is automatically updated? I have included a copy of my file. I have a follow on question that could be related. The data in my WORKAREA is active. Our administration process for that individual ends when he has transferred. How could we send his data to an archive and remove him from the active WORKAREA without cut and paste?

Hello,

The unique codes are under the MUS (AA Column). I was simply going to identify IDIV with an “I”, XDIV with an “X” and ADMIN with an “A”. I thought this might be easier to sort out. In column AD, the header is ACT or HIS, I was going to use this to sort active from historical. Thanks.

Hi,

Best solution, in my opinion, is to use Data Filter Advanced Filter ... twice

1. First time to copy to another location
2. Second time to filter remain in place, in order to use Specialcells Visible only ...and delete records ...

HTH
Carim