Results 1 to 6 of 6

Spreadsheet for audit report.

Threaded View

Starflex Spreadsheet for audit report. 01-19-2019, 06:34 AM
Mumps1 Re: Spreadsheet for audit... 01-19-2019, 12:16 PM
Starflex Re: Spreadsheet for audit... 01-19-2019, 12:51 PM
Mumps1 Re: Spreadsheet for audit... 01-19-2019, 02:14 PM
Starflex Re: Spreadsheet for audit... 01-19-2019, 03:56 PM
Mumps1 Re: Spreadsheet for audit... 01-19-2019, 04:04 PM
  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    9

    Spreadsheet for audit report.

    Hi all,

    I have been inactive for a few years, I hope I can find some help.

    In our organization, we carry out compliances audit to manufacturers (generally, heavy engineering). Various aspects are considered, and the reporting process is painful and time consuming.

    I am preparing an Excel spreadsheet where I can move the common data across, from one form to the other. The main problem I am having is to create automatically the "Observation" or "non-conformance" report, since one of each has to be created for each identified non-conformance or observation.

    In essence, the auditor goes to the manufacturer with a "checklist". This checklist is pre-filled by the Client, and the auditor verifies that what has been declared by the Client is actually present and implemented, through sample checks.

    If everything goes well, the auditor just report the evidence with a few notes.

    If something is not sparky clean, there are three levels of action:

    - Opportunity for improvement, which is a sort of "you could do better, but I am not worried"
    - Observation, which is a "hey, there is a threat here, take action before the next audit"
    - Non - conformance, which is a big "no" and the Client shall take immediate action.

    In case of Observation or non-conformance, the client is notified immediately with a report (generate from a template).

    What I would need is an automated macro that -when an observation or non conformance is reported in the checksheet by the auditor- generates a new OBS or NC form (from the template) with the comment made by the auditor.

    I am attaching the beginning of the file that I have generated. Can someone give me a hand?

    Thanks!

    Paolo
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Audit spreadsheet with drop-downs, colors, etc
    By Stephen74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2017, 11:02 AM
  2. [SOLVED] Audit Tracking Spreadsheet
    By excelrookie82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2014, 08:44 PM
  3. Macro to Export Data from one spreadsheet to a Report Spreadsheet
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2013, 03:59 PM
  4. [SOLVED] Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 05:10 AM
  5. need help with my report spreadsheet
    By albert28 in forum Excel General
    Replies: 1
    Last Post: 04-23-2010, 05:29 AM
  6. Audit report
    By mlk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2007, 07:31 PM
  7. Problems with Spreadsheet Audit Tool
    By ExcelMonkey in forum Excel General
    Replies: 0
    Last Post: 09-16-2005, 12:05 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