Results 1 to 4 of 4

Filter data to other sheets

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2006
    Posts
    4

    Question 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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1