How to make data stand out after selecting it in a filter

[Arnold]

Hi there,

I have a worksheet with about seven ranges (class periods in a school
day).

At the top of the worksheet is a list of students' names and other
info.

I would like to add a filter to the worksheet so that users (teachers)
could select a student, and the student's name or cell would either be
highlighted in all the ranges, or all the other student names would be
hidden in the ranges, making it easier for teachers to locate where a
student is at a particular time of day. Thankyou for any info you
could provide.

Arnold

 

[Dave Peterson]

You can apply data|filter|autofilter to one range on a single worksheet--you can
remove the filter and reapply to a different range if you want.

But maybe you could make a single giant table. Add an indicator column if you
need to help distinguish each group. Then you could apply a single
data|filter|autofilter to that range.

 

[Arnold]

Thanks Dave,

I appreciate the info and options. I don't suppose there's a
work-around for xl2003's Data>list multiple times for xl2002--sounds
like what I might want. I'll search some more. Thanks,

Arnold

 

[Dave Peterson]

You could have a macro that removes data|filter|autofilter from the worksheet,
then applies it to the current selection.

But it could be pain remembering what was filtered for which table.