Forum Discussion
The_Draco
Aug 18, 2022Copper Contributor
#SPILL - How to solve without splitting cells
Hello, First, my english isn't best, so hopefully you can understand what I want. Well, I need to get the value of a cell in one worksheet shown in a cell in another worksheet, problem is that ...
The_Draco
Aug 18, 2022Copper Contributor
Well, ok, found a solution, new formula:
=WERT(@'Blatt 1'!C12:BJ12)
I don't know why it wants till BJ12 as it is the last cell of the row of connectet cells and the "one" I want the value of is just C12:H12, but it works as I want it, so...
=WERT(@'Blatt 1'!C12:BJ12)
I don't know why it wants till BJ12 as it is the last cell of the row of connectet cells and the "one" I want the value of is just C12:H12, but it works as I want it, so...