I have a macro enabled excel file I created for my company.
Essentially, it's a huge dump of all parts our company handles and
the plan for those parts (PFEP - Plan For Every Part).
I programmed 8 macro buttons that, when a part number cell is selected and
a button is pressed, it automatically parses all information for that part into a
hidden sheet containing a label template, then auto-prints that sheet and rehides it.
In our part list, there are multiples of part numbers
(for the purpose that we use that specific part at multiple locations - need different plans for them).
Right now it is set up so that when one of the duplicates is selected,
it only gives the location information for the first part it finds on the way down.
It would be really convenient (for those who didn't participate in creating this document)
if there was a way it could grab, word-wrap, and concatinate the locations for all duplicates listed into that one cell.
I have pictures of file and code for an example sub in vba, and a copy of file ready on hand
I could share for a reference for you. Thanks for your help! Basically where it says "1.2 CS" in the picture uploaded, it needs to list all locations. not just the one for in that row selected. I have more pictures. File size limit restricts uploading spreadsheet.
Solved by A. A. in 29 mins