Hello,
I am creating a databse to hold Risk Assessments, when a new Risk Assessment file is created and saved into the correct specific folder, excel picks this up and automatically generates a hyperlink to that file and also when the file was created into the database.
In the new files that are created there will be a cell that highlights if the assesment is Low, Medium and High, is there a way for my database to find this information when a new file is created and place into the same database?
(When the Risk Rating is added, the revision due date will pick up when it needs revising based on whether the risk rating is Low, Med, or High. I have already worked out this formula.)
<tbody>
</tbody>
So as above, I would like the cell with red text to read the information from the newly created file - these file names will always be different - i.e. 101 Risk Assessment X.xlsm
Thanks in advance!
I am creating a databse to hold Risk Assessments, when a new Risk Assessment file is created and saved into the correct specific folder, excel picks this up and automatically generates a hyperlink to that file and also when the file was created into the database.
In the new files that are created there will be a cell that highlights if the assesment is Low, Medium and High, is there a way for my database to find this information when a new file is created and place into the same database?
(When the Risk Rating is added, the revision due date will pick up when it needs revising based on whether the risk rating is Low, Med, or High. I have already worked out this formula.)
| Title | Date Created | Revision Due Date | Risk Rating |
| Assesment X | 11/04/18 | Read Cell in File and add here |
<tbody>
</tbody>
So as above, I would like the cell with red text to read the information from the newly created file - these file names will always be different - i.e. 101 Risk Assessment X.xlsm
Thanks in advance!
