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.
Bookmarks