View Single Post
  #1   Report Post  
learnexcel
 
Posts: n/a
Default how to use a cell reference in a formula

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