dynamic path reference

  1. V

    Getting external data from Dynamic Path and Closed Files

    Hello, I'm trying to get external data from a number of different excel files across different Locations, WITHOUT needing to open the files. I want to aggregate all data from one year (on different Closed workbooks) into a single sheet (per store) on the Open Workbook . The Closed woorkbooks...
  2. C

    Dynamic file path

    I have a question about how to do something (or if it is even possible to do) in excel 2003. I have a single file that references various other files. A1=John Doe A2=='C:\My Documents\School\John Doe\[John Doe.xls]Sheet 1'!$H$5 A2 is not referencing A1 right now but I would like it to so that...

Some videos you may like

This Week's Hot Topics