How to apply a filter to multiple worksheets



Does anyone out there know if it's possible to apply a filter to several
worksheets at once?
I have a spreadsheet for tracking the progress of a portfolio of projects.
There are 7 tabs in all, and each tab shows different elements of the project
Each tab lists the Project ID in column B and what I would like to be able
to do is enter a Project ID into a cell on the front sheet of the workbook,
and then have all the subsequent worksheets only display the row that matches
that Project ID... Very simple to do in a database but I'm not allowed to use
one, and I can't figure out how to do it using Excel...



Peo Sjoblom

You might be able to use a pivot table to a certain degree using multiple
consolidation ranges.
Since it is a pivot table it will need some data to manipulate that probably
are of no importance
that could be hidden if it looks too interfering



Peo Sjoblom

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question