advanced filter

New Contributor

hi.. i am using advance filter to take cell info to another sheet, i call ,over view sheet, from my main sheet, however can this also be used to collect cell info from multi-able sheets back to my new over view sheet,

or is there a better way

cheers

Bill

2 Replies
If available, a better option might be to use the FILTER function.
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
Thanks Pat