Hi all
I have posted a similar question, however, thought perhaps to split the task up and break down the problem.
Is it possible to reference a cell in another spreadsheet, but this spreadsheet name will change on a monthly basis,ie : Jan_2011, Feb_2011, March_2011.
The primary spreadsheet will always remain the same yet the value in the cell may change based on the cell value in the above referenced cell (March_2011 for example)
in context I am want to ensure a spreadsheet shows the most up to date finish date of a project. At times this does change, which would be highlighted the March_2011 spreadsheet.
thought
thanks!
Bookmarks