Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Search in Multiple Worksheets
I have several worksheets that I use to calculate different types of information. The worksheets are similiar in the regard that they each have a project manager in the same column in all of them. What I like to do if a choose a project manager in one of the worksheets - I would like to see that Project Manager selected in all of the worksheets. e.g. If I choose C. Beason in worksheet #1 by using Auto-filtering then when I select worksheet 2 or 3 or 4, I would like to see C. Beason data displayed in those worksheets without using the auto-filtering feature each of the worksheets. Hope someone can help. -- Lizz45ie ------------------------------------------------------------------------ Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410 View this thread: http://www.excelforum.com/showthread...hreadid=477553 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search multiple worksheets | Excel Worksheet Functions | |||
Search multiple worksheets - Excel 97 | Excel Discussion (Misc queries) | |||
How do I search for a string across multiple worksheets in Excel? | Excel Worksheet Functions | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions |