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.