So the worksheets are not in the same workbook and are saved as individual
files, right? I don't think the indirect function works here. I too am
searching for a way to do this, if you find one let me know and I will do
same.

"miwarren" wrote:


Bare with me as I try to explain this.

I am working with an equation like the one below.

=[648455.xls]Sumbit!$L$9

I need a formula that will look in a cell to get the beginning number
for the equation.

Example

Say the number 648455 is in cell C75, I in turn need it to take the
number from cell C75 and place it in the equation as seen above and
then process that equation. I am not sure if excel can do this, or if
I will have to use a macro. You guys always seem to have the solution
so I figured I would bounce off you.

Please let me know if you need more info on what I need if this is not
clear.

Thanks so much for you help.

Mike (Nashville)


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=475955