Return cell value from closed WB using variable file path[s]

  • Hello,

    Is there a formula for returning a cell value from a closed WB using variable file paths???

    In Reports WB

    Column A is updated with a number of file paths (around 100), but will change as files are added or deleted from folder.

    I'd like for column B to be able to return cell B4 from each of the file paths listed in Column A.


  • You can't do that in one step, no. I've done similar, using formulas to generate the link formula that would work, but as a text string, then converting that to formulas afterwards. Do you see what I mean?

    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!