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 sort reference
is not valid. Make sure that it is within the data you want to
sort,and the first sort by box isn't the same or blank) Please help.
Regards
Yahya
On Apr 12, 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&forum...>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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
