EXCEL - Filter multiple sheets at same time?

[cutestuff]

hi,

I was told this was possible, but I've googled and searched and haven't exactly found anything.

We have multiple sheets in one excel file. There is one column that is the same on all the sheets. What we want is when we filter that column for a particular item, we want all the other sheets to filter for that item too. That way they can go from one sheet to another and see the information for the one they filtered for.

Hope this makes sense. Hope someone out here can help.

Thank you so much in advance.
Appreciate it.

 

[SkipVought]

Hi,

This can be done with VBA code. If you want to pursue a coded solution, please repost in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

_[red][/red]

 

[xlbo]

I'm afraid you have been mislead - this is not possible without VBA (as Skip has alluded to)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question