Payment sent to ozgrid.
I’m looking to have a macro look through several sheets in the same workbook. It would count how many times a product ID shows up and determine a software version based on another sheet in the workbook with a different lookup ID.
So on the Master sheer there will be the product ID in Column “A” and email address in Column “B”.
The UID in Column “A” looks through the Mon-Fri sheets and then outputs a count.
The UIB in Column “B” looks though the Software Sheet using email address to determine version which is in column “L”
See the attached mockup and let me know if you have any questions