I
IBM_Honda
I need a modest solution to a spreadsheet where two columns have 4-digit
codes for colors and a requirement to print out the actual color instead of
the code on a label. Since there are hundreds of theses colors to print
daily, I am looking for a macro or function combo that might detect the
4-digit code [ i.e. 01E0 ] and return the color [i.e. Flint] in the column or
fill an adjacent new column with the color. The Edit-Replace function would
work but there are dozens to do every day and then re-do the next day.
Obviously, attempting to automate the process with a macro.
Many thanks in advance for your assistance.
codes for colors and a requirement to print out the actual color instead of
the code on a label. Since there are hundreds of theses colors to print
daily, I am looking for a macro or function combo that might detect the
4-digit code [ i.e. 01E0 ] and return the color [i.e. Flint] in the column or
fill an adjacent new column with the color. The Edit-Replace function would
work but there are dozens to do every day and then re-do the next day.
Obviously, attempting to automate the process with a macro.
Many thanks in advance for your assistance.