Excel Data Manipulation

[BellKev]

Hello, need some help/guidance...

I have a spreadsheet, that spreadsheet basically summarizes work operations on a construction drawing. The idea is that I have someone go through a workplan, and populating this spreadsheet based on the drawings. My columns are somthing like "PLAN DESCRIPTION QUANTITY". Data in the sheet would look like this ...

401 Dig Trench 30
401 Place Material 30
401 Dig Trench 23
402 Dig Trench 50
402 Place Material 50

What I want to to is summarize this sheet on another ... so I want to run a macro (I'm guessing) that would first filter for everything with 401, then I would want to sum all the quantities for "Dig Trench" (In essence giving me the total distance to trench on plan 401). Then do the same thing for "Place Material" ... once all of the items on plan 401 are counted, then move to plan 402 and count the items ... and so on ...

Any suggestions on how to approach something like this?

 

[SkipVought]

Hi,

You don' need code to do this. Excel has many data analysis and data reporting features built in. The PivotTable Wizard can give you this kind of a report in a matter of seconds.

Data/PivotTable and PivotChart Report...

Skip,
[sub]
[red][/red]
[/sub]

 

[Bong]

Or subtotals if the data are sorted by Plan#.

_________________
Bob Rashkin

 

[BellKev]

This is great help guys ... appreciate the response ... I'm working with now to see how this will work for me ..

As a side question ... if there is some math I want to perform on the data in the pivot table ... is there a way I can add that as a column that is part of the pivot table?

 

[SkipVought]

Yes, you can set up new fields and do calculations in the pivot table. It's kind of klunky though, IMHO.

Skip,
[sub]
[red][/red]
[/sub]