We are a print management organisation who outsources all of our printing and decoration.
I have a excel spreasheet with many columns that tracks each job as it progresses through different stages and calculates estimated dates when the job should move to each subsequent stage. I am wanting to devise an easier way for our job control manager to track which jobs are due for completion of each of the 8 main stages of production.
I need an excel expert to write eight different filters for me that will show the jobs at each of the 8 main stages of production. Each filter will include relevant columns (provided by me) and will be sorted by one of these columns (generally a date).
For example: The first stage of our production is art approval so I would need a filter showing all the jobs for which we are waiting on art approval, sorted by date. When our client approves their artwork our job control manager would put in the date of artwork approval and then the job would automatically be removed from this filter and would move onto the next stage.
I have attached the excel document for reference.