Indirect Formula
I want to use the indirect formula so I can put the directory path in a cell
and link to it.
I want to link to a a spreadsheet located here - S:\Pricing\Performance
Templates\2005 Q3\Performance Templates\
The spreadsheet is called "Partner 1.xls" and the worksheet is called
"Review - Creditor" and I want to look at cell A1.
How would I write this?
Thanks in advance.
|