Hi All,
Currently in our department with run all our live and completed works off an excel spreadsheet. The sheet holds alot of different information, which currently I have to manually look up to produce a daily, then weekly report.
I'm wondering what formaula's I need to have this information "live" on a different tab.
For example :
In column C of the sheet, we have a date & time a job was promoted to us.
In column X, we have the date and time the job was completed
Each job has 4 stages and also sometime has multiple "sites"
What I would like to establish on the live report is :
The amount of jobs promoted on a certain date (ideally I would like a week commencing date in one cell, then the dates for Mon, Tues, Wed, etc)
The amount of jobs completed at stage 1 on a certain date
The amount of job (fully) completed on a certain date
Also, what needs to be included is if the job has multiple sites.
I hope this all makes sence (I know it does in my head in how I want it to look)
Currently in our department with run all our live and completed works off an excel spreadsheet. The sheet holds alot of different information, which currently I have to manually look up to produce a daily, then weekly report.
I'm wondering what formaula's I need to have this information "live" on a different tab.
For example :
In column C of the sheet, we have a date & time a job was promoted to us.
In column X, we have the date and time the job was completed
Each job has 4 stages and also sometime has multiple "sites"
What I would like to establish on the live report is :
The amount of jobs promoted on a certain date (ideally I would like a week commencing date in one cell, then the dates for Mon, Tues, Wed, etc)
The amount of jobs completed at stage 1 on a certain date
The amount of job (fully) completed on a certain date
Also, what needs to be included is if the job has multiple sites.
I hope this all makes sence (I know it does in my head in how I want it to look)
