Hey guys, New guy on the block , getting into some excel , hope y'all good around here.
I have a quick question, hopefully it has been resolved or someone has an idea of what it would be.
I have a Master workbook, that connects to Other workbooks for information , the other workbook are in ADJACENT folders or can be in SUB folders
example:
FOLDER A: Contains MasterBOOK , FOLDER B , FOLDER C , FOLDER D are all adjacent within the same DIRECTORY , each of those folders contain a workbook which the MASTERBOOK pull data from. from time to time , I have to move WorkbookA from FOLDER B to FOLDER C... so when i open the MASTERBOOK, the PIVOT Data displays error that WOrkbookA is not found.... now picture this with multiple workbooks and multiple times a day, it can be quite a headache trying to update it every time.... SO , is there a VBA Code that i can run or can run when i open MASTERBOOK to search for MISSING files and FIND them... Please note that The paths are ALWAYS absolute..
C:\ MAINFOLDER
-FOLDER A
MASTERBOOK
-FOLDER B
Workbook A
-FOLDER C
Workbook B
I can also have:
C:
MASTERBOOK
C:\MAINFOLDER
-FOLDER A
Workbook A
-FOLDER B
Workbook B
Please let me know if anyone knows if its possible!! thanks a million .
Bookmarks