Filtering by criteria

[Guest]

Greetings all. There may be a simple solution to what I need to do, but I
could not find it in terms I could understand. I have linked sheet2 to a
database view with various data. The view lists a job number, and types of
cable needed for each job. My problem is that my users do not want to see
the job number for every type of cable. For example my source data looks
like this:
JOB# Cable_type Footage
1 LT 24 1000
1 LT 48 500
1 MT 144 500
2 LT 24 1000
2 MT 216 500
On Sheet1 I want to add a column header for each type of cable, then sum the
footage from the footage column on sheet2 where the cable type = sheet1
column heading. Is this possible?

 

[Roger Govier]

Hi Greg

You data is ideally suited for analysis with a Pivot Table.
Mark your block of data>Data>Pivot Table>Next>Finish
Drag Cable Type to the Row area
Drag Footage to the Data Area

If you wanted, you could drag Job# to the Page area, and then use the
dropdown to select an individual Job and see the results for just that
Job. The default on dragging Job# to the Page are will be to show the
result fort All Jobs.

For more help on Pivot tables take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/flashfiles/pivot1.html

http://www.edferrero.com/Tutorials.aspx

 

[Guest]

Thanks Roger, It seems like this will take a lot of practice to get good,
but I think this is what I need.