Question

what is filter and difference between filter and advanced filter

Answer 1

Filter Data to Anther Sheet. The main reason that I use an Advanced Filter, especially when programming in Excel, is that it's a quick and efficient way to copy specific data to a different worksheet. In the screen shot above, the option is selected to copy the filtered data to another location.