Excel VBA concatenate table header txt for row/col intersections marked with "X"
Posted on 2011-03-13
I have a dynamic table with "i" rows and "j" columns.
The top row will have header labels.
The left-most column cells will be enumerated 1, 2, 3...
The next column will be populated by VBA
Besides these columns 1 & 2, the only content in the body of the table are "X" or blank.
I need help with the code that will enter into each cell of col 2 the concatenated text of the header label corresponding to each cell with an "X".
Table will be appox 150rows x 30col so looping will probably be slow and should be avoided if possible.