I have an MS Excel 2013 sheet that was working and now doesn't I can't seem to find the error. In the "Criteria Area" you enter search terms to sort the list below. I have submitted sample search terms in the cells for you.
You now click in cell "A9" to activate the table. Now go to the "DATA" tab and select "Avanced" in the "Sort & Filter" group.
The advanced Filter should come up with:
List range: $A$8:$J$21
Criteria range: $A$2:$J$3
Copy to: $A$26:$J$26
In the Advanced Filter dialog box select the radio button: "Copy to another location"
Then you click "OK"
You should see sorted returns in the fields below in the "Extract Area".
This was working but now it won't I can't seem to find an error as to why.