+ Reply to Thread
Results 1 to 2 of 2

Managing accreditation evidence table in Excel

  1. #1
    Registered User
    Join Date
    07-27-2023
    Location
    Queensland, Australia
    MS-Off Ver
    365
    Posts
    1

    Managing accreditation evidence table in Excel

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,572

    Re: Managing accreditation evidence table in Excel

    Hello jessk260 and Welcome to Excel Forum.
    I feel that a first step would be to show us how you would manually "show the status of each document (whether it is finalised or in progress)", so that we can attempt to replicate your output using formulas/code.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Managing pictures in excel
    By impala096 in forum Excel General
    Replies: 4
    Last Post: 03-27-2023, 03:01 PM
  2. Managing format of Word table when copying from Excel
    By jfjoyner3 in forum Excel General
    Replies: 0
    Last Post: 01-21-2022, 07:20 PM
  3. Removing evidence of forwarding with a macro
    By taylorsm in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 04-25-2017, 11:51 AM
  4. Very basic question: getting rid of all evidence of a macro
    By SuperheroChuck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2013, 11:36 AM
  5. Official Microsoft Accreditation
    By Gus80 in forum The Water Cooler
    Replies: 0
    Last Post: 07-17-2008, 11:01 PM
  6. [SOLVED] Managing Excel from VB^
    By Uwe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2006, 02:45 PM
  7. Digital Signature Visual Evidence
    By RjS, CISSP in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 07:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1