I have a master file consolidating everything I need and it is mostly references to other files that are exported with monthly data. I have one master file that is updated as those files are saved and has very little data that is manually entered. Not all of the reference files will be updated on a daily basis so I'm hoping to have a date stamp to show how old that specific piece of data is.
If I have a row in the master file that references data from a file called "File_1", can I have a cell in that row of the master file that has a date stamp of the last time that File_1 was saved? I've found some VBA code that would stamp in the master file if a cell was updated manually in that file but I can't find anything that shows when the formula is updated with new data from an external file. Is this even possible???
If I have a row in the master file that references data from a file called "File_1", can I have a cell in that row of the master file that has a date stamp of the last time that File_1 was saved? I've found some VBA code that would stamp in the master file if a cell was updated manually in that file but I can't find anything that shows when the formula is updated with new data from an external file. Is this even possible???
