D
Debren
I've seen this done, but I can't find out ANYWHERE how to
do it. Each column header has a drop down menu listing
all the possible fills for those cells (for instance, if
you're working in a database of addresses, and you're
looking for everyone from SC, when you click on
the "State" column header, all 50 states will be listed
alphabetically.) When you make your selection, the
addresses which fulfil the parameters are brought up.
It's like a sort, but all the rest of the rows are
hidden, and the rows retain their original number labels.
I hope I'm describing this adequately. Does anyone know
how to do this in Excel XP?
do it. Each column header has a drop down menu listing
all the possible fills for those cells (for instance, if
you're working in a database of addresses, and you're
looking for everyone from SC, when you click on
the "State" column header, all 50 states will be listed
alphabetically.) When you make your selection, the
addresses which fulfil the parameters are brought up.
It's like a sort, but all the rest of the rows are
hidden, and the rows retain their original number labels.
I hope I'm describing this adequately. Does anyone know
how to do this in Excel XP?