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

Excel 2007
Tables, Advanced Filter
http://www.mediafire.com/file/n5ntnztzdql/04_27_09.xlsx

Hi ,

Sorry cant reach the link below as get error message.

"Herbert Seidenberg" wrote:

Excel 2007
Tables, Advanced Filter
http://www.mediafire.com/file/n5ntnztzdql/04_27_09.xlsx

"Herbert Seidenberg" wrote:

Excel 2007
Tables, Advanced Filter
http://www.mediafire.com/file/n5ntnztzdql/04_27_09.xlsx

Worked really well, thanks

"Needing Help" wrote:

Hi ,

Sorry cant reach the link below as get error message.

"Herbert Seidenberg" wrote:

Excel 2007
Tables, Advanced Filter
http://www.mediafire.com/file/n5ntnztzdql/04_27_09.xlsx