Hi all!
Very simple question for Excel (not VBA). I have a cell, A1, which contains variable and changing text e.g. "C23".
In cell B1, I would like to refer to the cell address in A1, in this case C23, in another worksheet, Sheet2.
So for a specific known value, I would enter ='Sheet2'!C23...