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?
Bookmarks