Rewrite Code under Private Sub buildJur_Ing_ListingTab section of Create_Vendor_Module
Can you fix this code for me?
I need it look at C13 in Basic_Info_Tab. I think this cell is a named range of “COS”. This cell will contain concatenated values from a multi-select dropdown (like “United States of America, France, Antigua and Barbuda”).
Then I need to loop through each cell in range AA121:AA345 in Jur_Ing_Listing_Template, checking C13 for the value within the value, and hiding rows in the AA121:AA345 range if it isn’t found.
Then I want to copy/paste the sheet into a new one. I put that code you wrote for the previous one in there.
I thought I could figure it out, but I’m getting all kinds of errors.
Can you just look at the code I have and rewrite it so it does what I need?