I re-rea OP 7 times and still having hard time to understand the way it is written. It just downright bad, feels very contextual to the particular person's understanding.
If someone can rewrite it for easier read it is oughtta to be done.
Otherwise there are many other decriptions fot the usage of the relative, absolute and mixed references in the Spreadsheet applications. Most of Spreadheet applications work by some methods.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.