---------- Forwarded message ---------- From: Yahya <yahya...@gmail.com> Date: Fri, Apr 16, 2010 at 10:07 PM Subject: Re: $$Excel-Macros$$ Refresh Autofilter Automatically To: chreiner_p...@att.net
Sorry Paul, to bother you again.
Everything was working fine till I sorted the worksheets. Now I am getting
an error message "Run Time Error :1004" .The screenshot is attached. Please
help.
Regards
Yahya
On Mon, Apr 12, 2010 at 9:15 PM, Yahya <yahya...@gmail.com> wrote:
>
> Thanks Paul. This was what I needed. I used the code in the first sheet.
>
>
> Regards
>
> Yahya
>
>
>
> On Mon, Apr 12, 2010 at 5:54 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
>
>> You could create a Sheet Activate event that would refresh your filter:
>>
>> on the sheet tab name, right-click
>>
>> Private Sub Worksheet_Activate()
>> ActiveSheet.AutoFilter.ApplyFilter
>> End Sub
>> that way, whenever you change to the sheet, it would automatically refresh
>> the filter.
>>
>> Or,on the other sheet, create a change event.
>> like:
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> Sheets("Sheet1").AutoFilter.ApplyFilter
>> End Sub
>>
>> One problem I noticed in testing is: the filter seems to be specific.
>> for instance, (in excel 2007) the filter SPECIFICALLY says to display
>> values: "0.05", "0.50", "0.55", "1.30", "1.90", "5.70"
>> so if the changes result in a different value, it won't display.
>> You would have to change the custom filter to: <> 0.
>>
>> hope this helps.
>>
>> Paul
>> ------------------------------
>> *From:* Yahya <yahya...@gmail.com>
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Mon, April 12, 2010 9:47:32 AM
>> *Subject:* $$Excel-Macros$$ Refresh Autofilter Automatically
>>
>>
>> Hi
>>
>> I have
>> a<http://www.ozgrid.com/forum/autolink.php?id=6&script=showthread&forumid=8>utofilter
>> set
>> to filter on column D. The data in column D is updated from another
>> worksheet. If I update the other worksheet the cells in Column D do change,
>> but to refresh the autofilter, it has to be done manually.
>>
>> I would like to have the autofilter automatically refresh when the cell
>> value is changed. (ie I want the autofilter to refilter the column D, taking
>> into account the changes in each cell of the column). A sample file is
>> attached
>>
>> Your help is much appreciated.
>>
>> Regards
>>
>> Yahya
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
<<attachment: Runtime Error.png>>
