How can I get advanced filters to automatically update the filter when i change the criteria value and then pasted this filtered value to a new sheet every time i update the criteria ?
I have attached example of spreadsheet and some screen shots to try demonstrate what i am trying to do. is this possible to do using VBA ?
Don’t have an account yet? Register yourself now and be a part of our community!