Say the stand-alone cell containing 00036 is A1, then try this:


=INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\ 6\["&A1&".xls]Sheet1'!$U$31")-INDIRECT("'P:\PSReport\GLReport\STRPL\PAGE1\2006\6 \["&A1&".xls]Sheet1'!$U$30")

Regards,
Stefi


€žScott D.€� ezt Ã*rta:

I sure have had good luck in the past with people helping me out with
formulas on this board, hope my luck holds out this time as well.

I have a situation where my formula would be identical across many cells,
except for a unique reference point number listed in each formula. Is there
a way to change my formula to be generic and reference a stand-alone cell
instead of having the unique reference point number being imbedded in each
formula?

For example in the formula listed below, I need the formula to be modified
to reference the 00036 in a stand-alone cell. Any ideas? Thanks Scott D.

='P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$31-'P:\PSReport\GLReport\STRPL\PAGE1\2006\6\[00036.xls]Sheet1'!$U$30