Good Day all,
I'm a document controller and have multiple workbooks which contain document details, including the various dates that documents are due for submission. I deal with many projects and each have a workbook of their own. To help my manage all of these I have a workbook which contains hyperlinks to all the workbooks in one column and in another I put the next due date for that project. This way I don't have to check through all the workbooks everyday.
I was wondering if it was possible to write a macro which scans through all the open projects extracting the hyperlink to each one, then goes to that workbook, scans for the next document due date, stores the value and then returns it and stores it in the row for that project. Without opening all the workbooks.
I considered having a macro that checks for the next due date in each individual register then stores it in a cell and that way I can write another macro which in turn simply checks that cell of each workbook and returns the value, but I think that would mean I would have to open each workbook to update this cell.
This one is a big ask, so I figured it would be best to get some advice from the pro's before attempting to write something ridiculously complex myself. Any idea on the best way to do this would be greatly appreciated. Rep as always.
Cheers,
R
Bookmarks