Forum Discussion
Transfer Text from one cell to another cell in a certain sheet based on text input in another cell
Yep this is a doozer! I have a table in sheet 1, if a tick is placed in a cell on a certain row I would like text connected to that cell to be transferred to a cell in another sheet. Next trick is th...
Note carefully that last piece of advice from PeterBartholomew1
Do not get carried away with the formatting at this stage; you are engaged in software design, not graphic art design.
One of the most important principles of spreadsheet development. Make the spreadsheet function as you want first. Make it work as desired. THEN make it pretty. Introduce colors. Merge cells for headers.
Many of the things that make a spreadsheet "pretty" -- notably merging cells, other formatting things -- when introduced too early in the developmental process, actually can interfere with smooth functioning.
Right. I'll bare it down and start again. Thx.
Just to be clear you can't link the tick to copy txt to another cell or just not to another sheet?
And of you copy cells do the formulas if that what you call them copy too? They don't seem to
Just to be clear you can't link the tick to copy txt to another cell or just not to another sheet?
And of you copy cells do the formulas if that what you call them copy too? They don't seem to