Consolidate Data

[Rick Patterson]

Hello,
Using Excel 2002
I have a list of data brought over from Access. The list consists of
salespeople (names) in the "a" column and information related to individual
sales in the subsequent columns (Date, Tasks sold, total revenue, total
hours billed, etc.) Each row consists of one job and there may be several
jobs in one day.
I need to consolidate this list into a summary list by sales people names
for a particular date range on another sheet. I am sure this is an easy
task but I have not worked in excel for some time and have been beating my
head against this wall long enough.
Please Help this eternal novice!!!!!
Rick Patterson

 

[Earl Kiosterud]

Rick,

I presume from your question that there are multiple Sales Peoples names,
and each is to be summarized. If so, a Pivot Table is perfect. For the
date range, you can filter the list first (Data - Filter - Advanced filter).

 

[Ron de Bruin]

Try this Rick

http://www.rondebruin.nl/copy5.htm