I have a tracking spreadsheet that I use to track new safety incidents that happen at our workplace. When an incident occurs it is documented in a form that is then saved in a specific directory. This form is an excel spreadsheet. These forms are completed by our supervisors when an incident occurs. I then take a lot of the information from this form and copy it into the tracking spreadsheet.
Is there some way to automate this process? Can I have my tracking spreadsheet monitor the directory for new files and if they are detected, pull the relevant information from them and plop it into the tracking spreadsheet?
Sounds lazy, I know. But if it can be done, why not?!
Is there some way to automate this process? Can I have my tracking spreadsheet monitor the directory for new files and if they are detected, pull the relevant information from them and plop it into the tracking spreadsheet?
Sounds lazy, I know. But if it can be done, why not?!
