Closed

Microsoft Excel 07 - Filter Project

This project was awarded to binaryromel for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
25
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online