Mar 25 2020 11:35 AM
How would I be able to have a cell automatically update a text from another cell. For example, if I have a city in one cell (B3) called Shreveport, and I want it to also automatically fill in cell K3 when I type Shreveport in cell B3. And then when I delete Shreveport in B3 and type Columbus in B3, I want it to automatically update to Columbus in K3.
Thanks for any help.
Mar 25 2020 11:38 AM - edited Mar 25 2020 11:39 AM
Mar 25 2020 11:39 AM
To accomplish your example is easy. So easy, in fact, that one wants to ask you "Are you really wanting to do this? Or is there something else going on?"
Anyway, to do what you give as your example, nothing more, nothing less, just enter in cell K3 this formula =B3
It will fill, then (in K3) with whatever is in B3; Shreveport, blank, Columbus....whatever.
But is that really what you're wanting? Or is there something else?
Mar 25 2020 11:56 AM
It was that easy. My brain was just not working well I needed someone else to kick it. Thanks