Forum Discussion
Transfer Text from one cell to another cell in a certain sheet based on text input in another cell
"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"
Excel doesn't really work like that in that you cannot instruct it to transfer data.
A more useful view might be
1. You have a data source that comprises a list of tasks, a list of achievement standards and a list of content descriptions.
2. There are many to many relationships between the Tasks and the Achievement Standards represented by a crosstab of check marks. Given an item from one of the lists you can look up a list of related attributes. The same applies to the content descriptions.
3. To select the AS specific to any given task, you could use a formula such as
= FILTER(AS, XLOOKUP(currentTask, task, crosstab="x"))
Given that, your focus should shift to the sheets that present information based upon the data source. How you present the information depends entirely on your use case. For each cell of the report, you decide what data you wish to reference and how you wish to present it. Do not get carried away with the formatting at this stage; you are engaged in software design, not graphic art design.
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
