I’d like to link to a cell in an external calc document by using the content of a cell in the current document as reference for the sheet name in the external one.
Here’s what the direct link would look like:
I’d like ‘Sheet 1’ to be replaced by the value in cell A1 in the current sheet (not the external one).
I’ve tried using INDIRECT, but can’t get it to work the way I hoped it might.
I’d appreciate any pointers to the correct way of writing this reference.