Join 2 Cell to make a new formula

[racer25]

Hi All,

Been searching endlessly and read many posts and not been able to get anything to work.

I have a linked formula.

='G:\Monthly Reports\Monthly Reports 2007\January 2007\[January 2007 P&L.xls]Operating Revenue'!$E$109

This pull one cells from last years file I have around 1200 cells to pull.

In February the formula becomes.

='G:\Monthly Reports\Monthly Reports 2007\February 2007\[February 2007 P&L.xls]Operating Revenue'!$E$109


I have been trying to make a formula

='G:\Monthly Reports\Monthly Reports 2007\&A1&\[&A1&P&L.xls]Operating Revenue'!$E$109

So that I only change the value of A1 and the formula is updated accross the wholebook.

In theory I could do an edit replace - but I would like to do this properly.

Thanks in advance to anyone that can help.

[NBVC]

You would need to download and install the free Morefunc.xll addin from this site:

http://xcell05.free.fr/english/

and apply this formula:

Please Login or Register  to view this content.

[racer25]

Perfect thank you.

A lot of work saved.