Relative reference won't update
 

Hello,
I've got a row of about 8 formulas and contain and absolute and a relative
reference in it to another worksheet.
My problem is this:
A1 contains =INDIRECT("Database!$F2") and the rest of the column is
similiar.
I would like for the formula in A2 to increase to $F3 automatically as i
drag the formula's down, and continue for about 100 columns. This isn't
happening.

I get the exact same formula all the way down. Can anyone give me a hand
please. Thanks
BOB Reynolds

Relative reference won't update
 

Your F2 is inside the quotes and is therefore treated as a string and
does not increment. Try this instead:

=INDIRECT("Database!$F"&ROW(A2))

and then copy it down as required.

Hope this helps.

Pete

On Dec 20, 1:31*am, "LaborGuyRJ" wrote:
Hello,
I've got a row of about 8 formulas and contain and absolute and a relative
reference in it to another worksheet.
My problem is this:
A1 contains =INDIRECT("Database!$F2") and the rest of the column is
similiar.
I would like for the formula in A2 to increase to $F3 automatically as i
drag the formula's down, and continue for about 100 columns. This isn't
happening.

I get the exact same formula all the way down. Can anyone give me a hand
please. Thanks
BOB Reynolds

Relative reference won't update
 

That was the solution. Thank you so much
Bob

"LaborGuyRJ" wrote in message
.. .
Hello,
I've got a row of about 8 formulas and contain and absolute and a relative
reference in it to another worksheet.
My problem is this:
A1 contains =INDIRECT("Database!$F2") and the rest of the column is
similiar.
I would like for the formula in A2 to increase to $F3 automatically as i
drag the formula's down, and continue for about 100 columns. This isn't
happening.

I get the exact same formula all the way down. Can anyone give me a hand
please. Thanks
BOB Reynolds

Relative reference won't update
 

You're welcome, Bob - thanks for feeding back.

Pete

On Dec 20, 4:59*am, "LaborGuyRJ" wrote:
That was the solution. Thank you so much
Bob