How can I make it easy to re-apply a filter on a different worksheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-1902522%22%20slang%3D%22en-US%22%3EHow%20can%20I%20make%20it%20easy%20to%20re-apply%20a%20filter%20on%20a%20different%20worksheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1902522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20wish%20to%20make%20an%20Excel%202019%20.xlsx%20spreadsheet%20available%20to%20the%20public%20to%20download%20and%20use%20themselves.%20Users%20need%20to%20enter%20a%20parameter%20on%20Sheet1%20that%20is%20used%20by%20a%20filter%20on%20Sheet2%20which%20I%20don't%20want%20users%20to%20have%20to%20open%20in%20order%20to%20%22re-apply%20the%20filter%22.%20Is%20there%20any%20way%20of%20enabling%20them%20to%20invoke%20%22re-apply%20the%20filter%22%20on%20Sheet2%20from%20Sheet1.%20I%20thought%20I%20could%20simply%20instruct%20them%20to%20Ctl-Alt-L%20but%20this%20must%20be%20done%20from%20Sheet2.%20Is%20there%20a%20way%20of%20doing%20this%20from%20Sheet1%3F%20A%20VBA-macro%20would%20do%20this%20but%20users%20won't%20trust%20an%20.xlsm%20spreadsheet.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1902522%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I wish to make an Excel 2019 .xlsx spreadsheet available to the public to download and use themselves. Users need to enter a parameter on Sheet1 that is used by a filter on Sheet2 which I don't want users to have to open in order to "re-apply the filter". Is there any way of enabling them to invoke "re-apply the filter" on Sheet2 from Sheet1. I thought I could simply instruct them to Ctl-Alt-L but this must be done from Sheet2. Is there a way of doing this from Sheet1? A VBA-macro would do this but users won't trust an .xlsm spreadsheet.

0 Replies