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...
So I typed this out into one of my sheets with a filter and it worked perfectly. I then copied it into all of my other sheets with filters and the other ones won’t work. Any clues?
Without details, I'm afraid not. If the workbook doesn't have any sensitive information, or an example of what you're working with, could be uploaded, it would be helpful (click on 'open full text editor' and you should see the option to upload a workbook). If that's not possible, then perhaps elaborate more regarding how your data is set up and what you're trying to do (perhaps screenshots if possible and not sensitive information).