Hi,
Thanks in advance for your help. I have a workbook with multiple sheets (we'll call them A, B, C, and D). I would like to be able to create a shortcut/macro to filter A, B, C, and D for the same criteria that is located in column A for every sheet. I would also like a dialogue box to appear when I click on a keyboard shortcut where I can enter that criteria. Also, I'm not sure if this makes a difference or not but I run this set of reports every week so I would like for the macro to be available to every spreadsheet. I'm assuming if it's saved to my personal macros that this shouldn't be an issue. I really appreciate the help!

Kind regards,
Wendy