View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fullers
 
Posts: n/a
Default 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.