Hello Everyone,

Is there a way to type in a cell value in one spreadsheet and then have several auto filters sort based on that value? I'm thinking that maybe I can somehow link a data validated cell to my auto filters.

I currently have a spreadsheet that has data for several months listed out on separate tabs. I would like to create a "Master autofilter" that will make all of my auto filter fields sort at the same time. This would prevent myself or my manager from having to manually filter all of these tabs.

If anyone has any ideas I'd really appreciate it.