Hi,
I'm new to Excel and have been asked to put together document that shows the types of evidence we have to respond to accreditation standards and the status of each document etc.
So far I have a Workbook with 7 sheets (Domains 1-7) and have listed each Standard and sub-standard. I have then listed each piece of evidence. I need help working out the best way of demonstrating the status of each document (whether it is finalised or in progress) so that my boss can quickly monitor our progress towards meeting our accreditation submission deadline. I've uploaded an example of the raw data I'm working with for Domain 1, note that a number of these documents will be relevant to multiple Domains. My colleague also have another spreadsheet that she is using to track the status of documents however it is not linked to the standards and we are unable to monitor our progress against each standard from it. It would be ideal if I could link this new Workbook with her existing one if that's possible.
Thanks in advance for your help with this
J
Bookmarks