My proble is I have to use abbreviations in the cell Im writing in and then
when ever that word is placed in a cell I want it to transfer to a specific
cell in another sheet.Example: y11 would be placed in a cell in sheet 1 and
it would transfer to a cell in sheet three that said yard1????