Hello everybody!
There's something I have never been able to do before and I would like your help to resolve it. And what I realized is not as easy as it looks.
In this table below, I intend to go through row by row in columns B to H. Whenever a value other than 9999 and blank is identified, the cell in column A is filled with the column title that contains that value. In summary, I want to fill the Colors column with the names of the colors using VBA.
In addition, if there is more than one value in the line other than 9999 or blank, I would like all titles to be filled in and separated by a straight bar. Example: Yellow | Brown | Green
Anyway, there is an image of this table, a manual work. I tried to use code but the result was frustrating, hahahaha ...
I'll be waiting, thank you for your attention.
There's something I have never been able to do before and I would like your help to resolve it. And what I realized is not as easy as it looks.
In this table below, I intend to go through row by row in columns B to H. Whenever a value other than 9999 and blank is identified, the cell in column A is filled with the column title that contains that value. In summary, I want to fill the Colors column with the names of the colors using VBA.
In addition, if there is more than one value in the line other than 9999 or blank, I would like all titles to be filled in and separated by a straight bar. Example: Yellow | Brown | Green
Anyway, there is an image of this table, a manual work. I tried to use code but the result was frustrating, hahahaha ...
I'll be waiting, thank you for your attention.