I have a sheet with the names of the file path...in cells A1-400. I need to use these files paths as the location of where to get the range...how would I incorporate that...when i select it, it just shows up as A2...then it will think that is the range instead of the director to the actual range in the directory whihc would be A1:G200.
Thanks for any ideas
Thanks for any ideas