I need to reference a set of cells across many workbooks within a single file in order to compile a master workbook. This needs to be dynamic so when file names change I can easily update the file name with perhaps a referenced cell. At this point I can do one but to be able to drag it down using names on the side to locate the file name does not work. If you need further clarification let me know. Will be working on this one for awhile.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Refrence cells of multiple workbooks within same file
- Thread starter pwebley
- Start date
