Hello.
I want to create a link between one cell in one sheet, to another cell in another sheet. At the same time, I want Excel to understand that the cell directly to the left and to the right are also to be linked to the other sheet. Lastly, I want this to happen when I write the excact name of the cell I'm referencing, not necessarily using "=".
It is kind of difficult to explain, so I've attached some screenshots. Does anyone know how to do this, if it even is possible?
Please help!
