Filtering by criteria
 

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?

Filtering by criteria
 

Hi Greg

You data is ideally suited for analysis with a Pivot Table.
Mark your block of dataDataPivot TableNextFinish
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/f...es/pivot1.html

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


--
Regards

Roger Govier


"Greg Snidow" wrote in message
...
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?

Filtering by criteria
 

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

You data is ideally suited for analysis with a Pivot Table.
Mark your block of dataDataPivot TableNextFinish
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/f...es/pivot1.html

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


--
Regards

Roger Govier


"Greg Snidow" wrote in message
...
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?