linking 3 rows into one
 

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

--
Message posted via http://www.officekb.com

linking 3 rows into one
 

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


"steve bagdasar via OfficeKB.com" wrote in message
...
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

--
Message posted via http://www.officekb.com