Wondering if anyone can help me on this one please?
I am looking for a FORMULA to automatically copy TEXT typed into one cell to appear in another cell. The simple ="original cell" does not work for text, only for formulated entries.
The other issue is that I want to save all of this with formulas as a template, which when opened will automatically copy what I type in cell1 to cell 2. Everything I've tried just will not work.
Basically, what I'm after is that when I type something in the yellow box in this attachment in column "to" to be mirrored in the yellow box in column "from" in the next line down, all the way down the available slots
Thanks for any suggestions
I am looking for a FORMULA to automatically copy TEXT typed into one cell to appear in another cell. The simple ="original cell" does not work for text, only for formulated entries.
The other issue is that I want to save all of this with formulas as a template, which when opened will automatically copy what I type in cell1 to cell 2. Everything I've tried just will not work.
Basically, what I'm after is that when I type something in the yellow box in this attachment in column "to" to be mirrored in the yellow box in column "from" in the next line down, all the way down the available slots
Thanks for any suggestions