• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Refresh auto filter if Cell value changes

A

amit dani

New Member
hi Guys,

Is it possible to auto refresh filter on data if a particular cell value is changed. What I want to do is if I change value of cell "D1", filter on my data in A4:O60 should be automatically refreshed. Filter is on column G and criteria is amount does not equal to 0.
So every time I change cell "D1" my data table should show only non 0 rows.

Thanks
 
Hi Amit ,

What is the connection between D1 and the range A4:O60 ?

Is your criterion independent of the contents of cell D1 , or does the column G contain a formula which refers to D1 ?

On the Data tab , there is a button labelled Reapply ; all you need to do is click on this button ; do you want that this should be automated ?

Narayan
 
Hi Narayan,

Yes..values in column G is dependent on Cell "D1". It's better if it is automated, since this will be used quite frequently.

Thanks
 
You must log in or register to reply here.
Back
Top