Hi. I'm new to the board and thought I knew a lot about excel, only to find out I'm a mere beginner.
I have a cell, we'll call it A1 that has the text "John Doe" in it. I have another cell in my sheet that has the text "_____'s Annual Costs". I want the blank to be the contents of cell A1 so whenever I change A1, it automatically updates the other cell. Basically this is a text formula. Is there a way to do this? I've been trying for months. Thanks.
I have a cell, we'll call it A1 that has the text "John Doe" in it. I have another cell in my sheet that has the text "_____'s Annual Costs". I want the blank to be the contents of cell A1 so whenever I change A1, it automatically updates the other cell. Basically this is a text formula. Is there a way to do this? I've been trying for months. Thanks.