linking 3 rows into one

[steve bagdasar via OfficeKB.com]

I have rows of data which are complete shift records, 3 shifts per day.

Date Clerk shift Cash Credit total
12/4/04 Sam 1 $250.00 $300.00 $550.00
12/4/04 John 2 $220.00 $335.00 $555.00
12/4/04 Eric 3 $205.00 $390.00 $595.00
12/5/04 John 2 $220.00 $335.00 $555.00

I would like to temporary link all 3 shifts , into one day and view it in a report sheet that i dseigned. I give the user a start day and end day user form option.
Can anyone please help?
Thank You

 

[Bernie Deitrick]

Steve,

Select your data, then use Data | Pivot Table.

Drag the Date to the row area, and the sum to the data area, and you will
get a day-by-day summary.

HTH,
Bernie
MS Excel MVP