Hi,
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 ?
[ATTACH=JSON]{"data-align":"none","data-size":"full","data-attachmentid":1216234}[/ATTACH]
Thanks