I have an excel file with a list of projects (~500). Every active project has a hyperlinked status report. I want to add a column showing the date that the hyperlinked status report was last modified (so I can keep track of who is not updating their status reports).
Not every project in the list is active so not every row has a hyperlink.
Project Names are in Column A along with a bunch of other information in subsequent columns.
The Hyperlink to the Status report is listed in Column AI.
I want to put into Column AJ the date that the hyperlinked file was last modified.
Hyperlinks exist in Column AI between rows 4 and 500 (though not every row in column AI has a hyperlink)
I have found a few things online but have not been able to cobble together a functioning code.
Any help would be appreciated.