Hello,
I have a list of tools that I would like to combine into one string to report out to another worksheet. In the test book attached the list of tools is in B4:B8. In C10 I am wanting to combine a string of all of the tools that have a "Y" by them in column A. So far I haven't been able to come up with a good way to do this for a larger set of tools. The test book only has a list of 5 tools, but the actual workbook has over 100.
Thank you!
Bookmarks