Hi Bernie,

How can I make this formula adjust for column movement too ?
I tried to do the same as you did with Row by using COL but it doesn't work
that way.

Thanks for your help.

Orlando


"Bernie Deitrick" wrote:

There are quite a few ways. Here's one:

=INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!D" & Row(A483))

HTH,
Bernie
MS Excel MVP


"ORLANDO VAZQUEZ" wrote in message
...
Hi,

How can I re-write this formula so that when I copy it down 1 row the
ref_text portion !d483 changes to !d484 ?

=+INDIRECT("'"&'ACCOUNT MASTER'!$AH$6&"'!d483")

Please help.

Thanks,
Orlando