Hi, im trying to create a summary workbook for pulling though data from Various work books when the variable path is defined.
The other work books are stored in different locations and i can save a database of these file paths within a different worksheet within the current summary workbook.
For the summary page i am pulling thorough the defined workbook paths to cell B5 e.g. cell B5 States "C:\Users\user\Box\03 - CONTRACT\01 - Live Jobs\128 - Seven Junction\1 Financial\[Material Order.xlsm]Mat Summary"
within the current summary workbook i want cell C9 to look at the path within cell B5 and then make it equal to that workbook and worksheet cell D5.
But i just dont know what to type into cell C9 to make excel understand this path.
hope this makes sense and someone can help.
thanks
Danny
Bookmarks