Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

=INDIRECT(N$1&"."&"E11")

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.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.