Help with INDIRECT()

[Sophat]

Hello,

I'm trying to keep my references when I drag and drop from one cell t
another so i'm using INDIRECT("D7") for instance. Thing is i want t
drag fill the function but i want D7 to change dynamically, fo
instance INDIRECT("D8") or INDIRECT("E7")

Thanks in advance. :

 

[JE McGimpsey]

I'm not sure what you're asking for. It sounds like:

A) you're using INDIRECT so that the references don't change dynamically

and

B) you want the references to change dynamically.

It's hard to see how you could have both.