N
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!
"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!