advanced filter

Copper 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



2 Replies
If available, a better option might be to use the FILTER function.
Thanks Pat