In the attached the code works for the item number located in Cell A1 on worksheet "801" when double clicked
I would like to filter the "Data" worksheet by double clicking on any item # in range "A3:A11" on any of the other worksheets "801,802,803". Original workbook that I will adapt code to has 45+ worksheets.
Item #s are unique.
Thank you for your assistance![]()
Please Login or Register to view this content.
Bookmarks