Question

What is the advantage of advance filter.​

Answer 1

The Advanced Filter gives you the flexibility to extract your records to another location on the same worksheet or another worksheet in your workbook.