Referring to changing spreadsheets in a function

  • Thread starter Thread starter Dianne
  • Start date Start date
D

Dianne

I want to enter a file name and location into a cell, then
refer to that address inside a formula.
eg R1C1 = FileName1, R1C2 = SUM([FileName1]!A1:A3)
R2C1 = FileName2, R2C2 = SUM([FileName2]!A1:A3)

I have a whole series of FileName files all to be
referenced this way. How can the formula automatically
pick up the location reference in the first column, so I
don't have to enter into each formula separately?
 
= SUM(INDIRECT("FileName1!A1:A3"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referring to Cells in a forumula using a function 2
Importing multiple text files to 1 spreadsheet 3
Help converting a vb6 function to vbnet. 8
Circular reference, Indirect, and Sum 3
Run time error 53, cannot find file 3
Locking a cell reference in a formula 1
Variable in a filename reference in Excel 2000 1
Finding the cell loacation that matches a specific value in a rang 3

Back
Top