Lets say that the words are A, B, C, D. Monthly spreadsheet working with have words E, F, G, H How can I associate a cell in this specified column to auto change / rename / replace: E as A, F as B, G as C, H as D. One step further, adding multiple associations for one word. E & I as A, F & J as B, G & K as C, H & L as D Compounding as many additional words that may relate to the 4 only permitted words. Using letters to make this more simple.
Solved by Z. J. in 21 mins