I would like to figure out how to make a text-box, where the content can make location to different cells, updating functions in the sheet that link to the particular content.
A4: 5
C5: 15
B6: =A4+C5 : = 20
The content of A4 is moved to D4, as the sheet is updated.
The function in cell B6 (=A4 + C5) automatically changes to (=D4+C5 : =20)
Is that possible, also allowing to update multiple entries by altering the entries it is comprised of?
Hallo
given your example, select A4 type <ctrl><x> … select D4: type <ctrl><v> voila!
I’m looking for a more automated process, for complex calc-sheets. The manual approach contradicts the intent, requiring immense manual efforts every time a new line is added, in a sorted data-set (pushing D4 to D5 etc., requiring the manual update of the function).
Thanks for the inquiring reply.
Try before you post false claims!
Formulas are updated if you insert|remove Rows|Columns or do some sorting
I apologize for the detail, making such an error as a false claim. The example that sprang to mind, highlighted a function as non-existent, that does exist - which is very neat. However, I did need to manually update more than one function, after a while of working the calc sheet.
Also, I am looking for a broader solution. Were I to utilize a text-string, such as “soul” (could be tagged as “component_to_a_being”), in several other text-strings such as (“the AI is with a $component_to_a_being”) or (“dependence may form in the $component_to_a_being, as a life is consumed in certain ways”).
Looking at the initial post I wrote, I see I slipped and made a lingual error as well. The errors were particularly time-consuming, as an outcome seem to be dis-empowerment. I was unable to be aware of how, particularly in this space, such a failure is looked down on and drains the trust in a person and the words they speak. I was heavily oppressed, as many others are, which led me to speak out against this wrong. The oppression is caused to be broadly consumed, despite not actually benefiting, and as such there is immense demand, that the fulfillment-approach should not be contradicted (certainly desired “a false claim”). Despite that, the harm of the oppression is a major problem for civilization, of course the oppressed and the passive consumers thereof. The latter suffer already now, by what can be metaphorically described as being in a heavily polluted environment - I doubt I can elaborate without simply triggering denial. I am writing an article on the topic (anonymously), for the broader public, that may serve to make that clear and easy to understand. During the process of formulating the content for a smaller population-segment, I experienced exposure to intense denial, manifest through various factors - including within. The latter I believe to be a product of brainwashing. While this of course is a bit off-topic, I hope I will be forgiven for these errors. By the way, I utilize libre-office writer in the process, although I formulate the initial text using the nano-editor!