Filtered results displayed in a dropdown list?

[Not Me]

In an Excel 97 sheet that tracks auto repair expenses by "date", "type",
"cost" and others, I've been able to run conditional sums to track the
number of "type" and the total "cost" for each "type". I've also been able
to show "cost" totals for each year in the history file.

These are simply displayed as
Year 2000: $nnn.nn (total occurrances in that year)
Year 2001: $nnn.nn (total occurrances in that year)
etc.
and as
TYPE 1: $nnn.nn (total occurrances of type)
TYPE 2: $nnn.nn (total occurrances of type)
etc.

What I would like to be able to do is to click on either each year ("YEAR
2000") or each type ("TYPE 1")from these lists as one would do with a html
link or as a dropdown list and have all the associated entries display with
all column headers in a list.

Can anyone point me in the right direction on this? I would imagine
filtering would achieve the listings of relevant entries but I want the
listing "hidden" until I call it up by clicking on the describing cell.
Then the list would expand for display.

I'm sure this could be described better but I hope there's enough to make
my point!

Thanks for any help!

 

[Debra Dalgleish]

You could build a pivot table from the data, with Year or Type in the
row area, and cost in the data area.

Then double-click on any Cost, and a new sheet will be created, with the
detail from that total.

There are instructions and links for pivot tables here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Not Me]

You could build a pivot table from the data, with Year or Type in the
row area, and cost in the data area.

Then double-click on any Cost, and a new sheet will be created, with
the detail from that total.

There are instructions and links for pivot tables here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Interesting suggestion and I've been looking at and learning from your
site. I've played with the pivot table somewhat and I like the way you can
either call up each entry or, by 2clicking the total relative entries. The
one thing that I don't care for is the creation of a new sheet for it.

Am I reaching for too much by thinking I can create a temp listing that
would float over my main sheet and close/disappear when I close it?

 

[Peo Sjoblom]

Interesting suggestion and I've been looking at and learning from your
site. I've played with the pivot table somewhat and I like the way you can
either call up each entry or, by 2clicking the total relative entries. The
one thing that I don't care for is the creation of a new sheet for it.

Am I reaching for too much by thinking I can create a temp listing that
would float over my main sheet and close/disappear when I close it?

You can create the pivot table on the same sheet, when you set up the pivot
table
you have an option of putting it on the same sheet, if you don't it will
default
to a new sheet


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Debra Dalgleish]

Another option is to create the pivot table on a separate sheet, then
view both sheets. To view the main sheet and the pivot table sheet:

Choose Window>New Window
Choose Window>Arrange
Select Tiled, and check the box for 'Windows of active workbook'
Click OK