Forum Discussion
Auto Update of Filters
I have a combo box on page 1 On page 2 the value of the selection from page 1 is in a cell. Other cells then refer to it and return either 1 or 0 depending on the value selected. These values are...
Try this. Right click on your worksheet tab that has your autofilter, select view code, and past this into the code window that appears. Then, close the vba window.
Private Sub Worksheet_Calculate()
On Error Resume Next
Application.EnableEvents = False
Me.AutoFilter.ApplyFilter
Application.EnableEvents = True
End Sub
Thank you so much. 🙂
I ended up creating blocks of data for each filter option then using a lookup formula. It worked OK but what a job to do!