Ok thanks KJ
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
Payment sent and thanks for your quick help!
1) I hadn't but I have now.
2) No problem, the first 3 digits will determine the building. Right now 01(A,B,C,D,E) and 02(A,B,C,D,E) are East, 03(A,B,C,D,E) is West and 04(A,B,C,D,E) is North. It may expand in the future but those are the current criteria. Let me know if that clears up the conversion.
I have data that has an ID column, the first 3 digits corresponding to a building name. I want to be able to run a macro that will take the first 3 letters and then convert it to a column with a name of the buildimg. As you can see sometimes the first 2 digits are the same but the 3rd digit could be A, B, C, D or E.
The sample sheet shows in columns A-C the data I get and columns F-I show how I would like the data to look after a macro run.
Let me know if you need more info to build out the macro.