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.


    Thanks

    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!

Register Yourself Login