I have a workbook with 156 sheets.
It is a list of shelf life products with dates that they need to be tested. I want to search for a specific date throughout the sheets and return a list of all products that need to be tested on that date.
The dates are in column c and the product name i want to be returned is in column A.
Thanks for the help.
Bookmarks