Help with Formula Reference Point

[Guest]

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

 

[Guest]

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:

 

[Guest]

Stefi,

Thank you so much for taking the time to help me with this problem. Your
solution is going to save me a great deal of time and effort. I really
appreciate the fact that you took the time to actually write out the solution
for me rather than just telling me to use the INDIRECT function. I wish
there was some way I could repay you for sharing your expertise with me.

Scott D.

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