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.