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.