I'm having a problem with dragging the formula so it adapts to each line. The problem is that I'm trying to show the result of a column of one book in another, but in book one the results are only in pairs cells, and in book it's in all cells.
For example:
Book 1:
K6
K8
K10
Book 2:
K6
K7
K8
The problem is that I put in the first two formulas like this
K6='Book 1'!K6
K7='Book 1'!K8
And then drag.
And then the results appear something like this:
K6='Book 1'!K6
K7='Book 1'!K8
K8='Book 1'!K8
K9='Book 1'!K10
K10='Book 1'!K10
And so on, always repeating.
Any suggestion for avoiding the repeat?
For example:
Book 1:
K6
K8
K10
Book 2:
K6
K7
K8
The problem is that I put in the first two formulas like this
K6='Book 1'!K6
K7='Book 1'!K8
And then drag.
And then the results appear something like this:
K6='Book 1'!K6
K7='Book 1'!K8
K8='Book 1'!K8
K9='Book 1'!K10
K10='Book 1'!K10
And so on, always repeating.
Any suggestion for avoiding the repeat?