Microsoft Excel 07 - Filter Project

IN PROGRESS
Bids
25
Avg Bid (USD)
$187
Project Budget (USD)
$30 - $250

Project Description:
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.

Skills required:
Excel
Additional Files: job+Tracker2.xlsx
Hire Smokeydawson555
Project posted by:
Smokeydawson555 Australia
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 300
in 5 days
Hire nagybatonyi
$ 80
in 2 days
$ 50
in 3 days
Hire ssawatzky
$ 150
in 14 days
Hire frehmanpk
$ 200
in 1 days
Hire SilviaT
$ 40
in 0 days
Hire pavanasamr
$ 80
in 3 days
$ 150
in 2 days
Hire sreepn
$ 30
in 10 days
Hire hamidbashirawan
$ 50
in 3 days