'How do you filter an excel table with a cell reference?
I am trying to make my spreadsheet more dynamic and would like the tables on the second and third sheets to automatically filter based on a value entered in a cell on the first row. Any ideas?
I have tired to enter the cell reference in the advanced sorting section but it just reads the formula for the cell reference as text and shows zero results.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|