Creating a Summary Sheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

template creates invoice - how to create summary worksheet? 13
Update Summary Sheet Automatically 7
data to summary sheet for a dummy 0
Advanced Filter Problem 3
Help creating a summary tab (strategy) 1
Excel Workbook, Data Selection by Date 8
last entry in a range? 2
Annual Leave Summary 2

Top