I require assistance in developing some VBA code to return multiple lookup values into one cell.
So for example, I have part numbers that can be at different stock locations. ie
Stock Locations (worksheet)
I want to summarise the locations for each part number as below.
X A10, A13, A16
Y A11, A14, A17
Z A12, A15
Note all the locations are in one cell and the returned text has been trimmed to remove the text "-Front". Also I dont want duplicates to appear as in Z A15-Front which appears twice on the list.
I require a macro that will run from another worksheet as the stock location spreadsheet will be a fresh download weekly.
My VBA is improving slowly but this is way beyond me. Any help is greatly appreciated.