View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LaborGuyRJ LaborGuyRJ is offline
external usenet poster
 
Posts: 6
Default 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