How to apply a filter to multiple worksheets

G

Guest

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
process.
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...
 
P

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



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 

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

Similar Threads

Excel lookup across entire workbook 1
Checkbox issue - Checkbox overlapping when filter is applied 1
Searching for a text in different worksheets in a different workbook 0
Macro to format multiple worksheets 24
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
trying to create a link to a link in Excel (2007) 3

Top