Hi there
I have aproblem that I do hope someone can help me with:
In Cell A1 I have a part of a path as text: C\mads\private\
In Cell A2 I have the rest of the path still as text: [min 2015.xlsm]Feb'!$C$9. This part of the path is getting information from cell C9 on Sheet Feb.
In A3 I want to write the two parts of the path as a formula so I can get the informaion from document min 2015.xlsm ceel C9 on sheet Feb. Is that possible??
Thank you in advance.
Regards
Mads Alring
Re: Concatenate text in cells to a formula.
Hi Again
I know that I'm missing a ":" after C i celle A1. Sorry.
In call A3 the formula should be:
=SUM('C:\mads\private\[min 2015.xlsm]Feb'!$C$9)
Thank you
Re: Concatenate text in cells to a formula.
There is a problem to finding a solution to what you want to do.
The answer should be
=SUM(INDIRECT(A1&A2))
but you cannot use INDIRECT in connection with a closed workbook. it will return an answer of #REF!
Re: Concatenate text in cells to a formula.
Hi Batman
You saved my day. Thank you for the help.
As long as I in A1 write [min 2015.xlsm] and in A2 write Feb'!$C$9 then all is perfect. And as you said the other document have to be open.
Regards
Mads
Re: Concatenate text in cells to a formula.
No problem. Glad to have been of help.
Don’t have an account yet? Register yourself now and be a part of our community!
