I want to reference a cell in another sheet, and the formula I get when pressing
= followed by changing sheet, clicking on the cell and pressing Enter, gives me
Which is fine, except that cell B3 in Sheet1 contains the name of the sheet to select from.
So how can I avoid hard coding the name of the sheet and instead use the value of a cell as the sheet name?
I've googled and looked up OOo documentation and wikis, but to no avail.