Here's a challenge to the Excel Guru's out there.
I have a workbook that is linked to many other books. Each week the path of the link changes to a different folder. I've parsed the path into several cells and only need to change a single cell with the new date and all of the parsed cells...