how to use a cell reference in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to pick up info from a cell (B2) defined in a file (F1), which is
not open. With Excel I can do it without problems. My problem is that the
filename F1 is defined in another cell (A2) on this worksheet. How can I then
reference to cell B2 of file whose name is in A2 of the currently open
workbook ?

Regards
 
If the other file was open it would of course be an easy thing to do with an
INDIRECT formula, but it seems to work only for open workbooks(?)
So my suggestion would be to construct a macro that does one of the following:
a) open the file to read from
or
b) put together the reference in the cell

Maybe b) is more interesting if you want to do this for a lot of files.

/Marcus
 
You must log in or register to reply here.

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

Vlookup and return sheet name also 2
countifs Function not giving desired result with date criteria 2
Copying formulas across columns 2
With F1 value, look at A, if match or partial match return B 5
Can I use the NOW() function in a formula? 2
Locking a cell reference in a formula 1
Excel 2003 - Copy Down Function to Reference Next Worksheet 3
Excel check value i cell 6

Back
Top