Hi
I have a summary spreadsheet that links to all the spreadsheets in a certain folder to summarise the data.
Is there any way for excel to notify if there are any new files in that folder that dont appear on the summary spreadsheet? ie if someone has created a new file.
At the moment I have to periodically check the folder for new files and add if necessary.
Thanks
I have a summary spreadsheet that links to all the spreadsheets in a certain folder to summarise the data.
Is there any way for excel to notify if there are any new files in that folder that dont appear on the summary spreadsheet? ie if someone has created a new file.
At the moment I have to periodically check the folder for new files and add if necessary.
Thanks