To each item, identified by column B in rawdata sheet, add in column G the shelf location, found in data2, lookup for ID. Then for each box, identified in column A, make a PDF, having the same header
Relevant Skills and Experience
I have a lot of experience with VBA. I already created a draft of the macro that makes what you required, add shelf location, generate a PDF with the specific format you have asked
Proposed Milestones
$50 USD - After the project is finished and you are satisfied with it
I cannot send the draft of the macro, as per frlncr terms, if you are interested please contact me