So I have, what I think, is a somewhat complicated scenario that I need to solve. I have bits and pieces but can't seem to get it to all come together in to the end result I am seeking.
I have a single workbook.
Two worksheets.
Sheet 1:
ItemNames in column A and Locations in column B.
There...