Hi there,

I'm very new to VBA and would really appreciate help/advice. Attached is a simplified version of my spreadsheet but essentially I would like a macro which does the following:

1. Search along row to see where text is found in the 'Applicable' columns
2. Where found, list column heading(s) to 'Applicable Tables' column (Column K) using line breaks
3. Continue to next row and repeat

Hopefully that makes sense, happy to explain further if needed.

Table Screenshot2.PNG


Thanks in advance!