Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to replace a word with a word from other column?
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. |
#2
|
|||
|
|||
Try a vlookup, IBM (with your "color table" on a separate sheet---even a
hidden sheet): http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "IBM_Honda" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ability for Excel to find and replace graphic objects (like Word) | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
How do you replace a work sheet in excel with a word document? | Excel Discussion (Misc queries) | |||
Word: replace ... ... with space | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |