Hello all,
I am looking for a few pointers as to the best way of dealing with this situation.
Say:
Col.A, Col.B, Col.C
Material, Qty, Rate
Cement, 1, 3.00
Sand, 5, 2.50
Cement, 3, 2.50
Cement, 3, 3.00
I would like to total all the Cement, Sand and whatever else may appear but I wish them to be totalled also within discreet Rates.
ie:
Cement, 4, 3.00
Cement, 3, 2.50
Sand, 5, 2.50
I am not aware of which headings will appear nor rates and quantities.
I have contemplated Data, Consolidate - SubTotals and Pivot Tables ... any other suggestions?
These 'summary results' are then to be copied elsewhere on the worksheet.
I trust their is someone out there to help me in the right direction.
Cheers
S.
Sorry the Columns looked really pretty when I typed it out .. honest!
This message was edited by Sam40mUK on 2002-04-03 10:28
I am looking for a few pointers as to the best way of dealing with this situation.
Say:
Col.A, Col.B, Col.C
Material, Qty, Rate
Cement, 1, 3.00
Sand, 5, 2.50
Cement, 3, 2.50
Cement, 3, 3.00
I would like to total all the Cement, Sand and whatever else may appear but I wish them to be totalled also within discreet Rates.
ie:
Cement, 4, 3.00
Cement, 3, 2.50
Sand, 5, 2.50
I am not aware of which headings will appear nor rates and quantities.
I have contemplated Data, Consolidate - SubTotals and Pivot Tables ... any other suggestions?
These 'summary results' are then to be copied elsewhere on the worksheet.
I trust their is someone out there to help me in the right direction.
Cheers
S.
Sorry the Columns looked really pretty when I typed it out .. honest!
This message was edited by Sam40mUK on 2002-04-03 10:28