Refreshing AutoFilter in Linked Worksheets
- From: EonZ <EonZ.2atj20_1152684003.2486@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Jul 2006 01:58:11 -0400
Here's my dillema:
I have 2 worksheets which have the identical data. The second worksheet
is completely linked to the first work***:
For example, the value for A1 in the second worksheet is =Sheet1!A1.
The second *** is supposed to show values in the "Rank" Category that
are only equal to 5. The first *** has about 100 "Rank" items listed
from 1-5. *** 2 is autofiltered to only show values equal to 5.
The problem arises when I add new items in *** 1 with a "Rank" of 5
and those items are not showing up in *** 2. But when I click the
drop down and select "(All)," then the values show up. Basically, ***
2 doesn't automatically refresh after I add a new value to *** 1.
I want to know if there is a workaround for this? PLEASE HELP!
Thank you. :)
--
EonZ
------------------------------------------------------------------------
EonZ's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36273
View this thread: http://www.excelforum.com/showthread.php?threadid=560557
.
- Prev by Date: Transpose drag-and-drop
- Next by Date: Re: Transpose drag-and-drop
- Previous by thread: Transpose drag-and-drop
- Next by thread: Re: Refreshing AutoFilter in Linked Worksheets
- Index(es):
