Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking rows | Excel Discussion (Misc queries) | |||
linking rows | Excel Worksheet Functions | |||
Linking Rows? | Excel Worksheet Functions | |||
Linking rows to a column | Excel Discussion (Misc queries) | |||
Linking rows to a column | Excel Discussion (Misc queries) |