I have a cell that contain sheet's name (N1). I wrote a formula that uses cells in the sheet pointed to by N1.
Is it possible to copy this formula so that the cell references it contains (to the other sheet) changes along accordingly?
The way I'm using cells of a dynamically determined sheet is using INDIRECT, e.g.
which would output cell E11's content of sheet pointed to by N1.
So, I would like to copy this formula down to the next cell so that it outputs the contents of cell E12 of that same sheet pointed to by N1.
As "E11" is a string value, Calc doesn't know to increment it.