Hello all,
I have a problem I'm struggling to solve.
The attached workbook links data from several workbooks in the same folder. They have to be in seperate workbooks to integrate with some of our school systems.
Example of the COUNTIF and the directory isI want to pull in some data from each of the workbooks to do some analysis, but I cannot seem to get the data unless the workbook is running.Please Login or Register to view this content.
Does anyone have any VBA that can retrieve data within a range in a closed file?
Cheers
Luke
Bookmarks