Create a List

[Glenn]

I have a table with two worksheets.

The first one has membership data. Fields such as Status, Unit, Building.

The second worksheet has totals of the different categories that it counts
from the data in table one (for example how many active members (status)
there are in Unit 3 (Unit), in Building 1 (Building).

What I'd like to to be able to do is click on one of the totals in the
second table and have it generate a list of all the people that were counted
to make up that total.

Thanks.

 

[Dave Peterson]

Depending on how your data is laid out, you might be able to get that "drill
down" effect by creating a pivottable. You can double click on a cell in a
pivottable and it'll create a new sheet with just the entries that were used for
that total.

But you might be happy by applying Data|filter|autofilter to your range. You
can use the dropdown arrows to show/hide the info you want to see/hide.