I have Cell B1 = 6 on a worksheet named DOC. On Cell B3 of worksheet Week 1 it has "Celina". Is there a way that if Cell B1 in DOC has number 6, Cell B3 on Week 1 will automatically become Celina.
All worksheets are in the same workbook
Likewise if Cell B1 ever has any of the following numbers, cell B3 in Week 1 will display the corresponding alaphnumerics.
1 = Troy
2 = Piqua
3 = Urbana
4 = Grnvl
6 = Celina
Thank You
Bookmarks