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