Hi all,

I'm using the advanced filter to copy certain rows of data containing a "Y" in one column into a second sheet - this is for use on a dashboard and those "Y"s appear against different records according to which week/teacher/year group etc the user selects on the main page. Of course the one (fairly major) problem that I'd missed when I started making it is that the advanced filter doesn't automatically update!

So, I was wondering whether there might be a clever way that VBA could be used to update/re-run an advanced filter whenever a change is made to other worksheets? I've searched for quite a while but only managed to come up with one that works on the standard filter so far, sadly my knowledge of the coding side of Excel is a bit limited

Thanks for reading

Adam