N
Needing Help
I am fairly new to Excel and have been asked to create the following:
A spreadsheet with information such as:
Cust No, Job Description, Job Status, Start Date, End Date, Entry Date,
etc, etc
There could be several entries under one customer number with the Entry Date
and the etc columns containing different information.
I need to find a solution to create a summary sheet that allows me to type
in a date range at the top e.g Summary from 20/3/09 - 19/4/09
then I require a one line entry which summarises all the activity for that
period for each customer number.
Hope this makes sense as I am still trying to get my head around this request.
Thanks
A spreadsheet with information such as:
Cust No, Job Description, Job Status, Start Date, End Date, Entry Date,
etc, etc
There could be several entries under one customer number with the Entry Date
and the etc columns containing different information.
I need to find a solution to create a summary sheet that allows me to type
in a date range at the top e.g Summary from 20/3/09 - 19/4/09
then I require a one line entry which summarises all the activity for that
period for each customer number.
Hope this makes sense as I am still trying to get my head around this request.
Thanks