Building "Audit" system in Excel

JaredMcCullough

Well-known Member
Joined
Aug 1, 2011
Messages
516
I was wondering if anyone had any experience developing an "audit" system in excel?? So as to I might not have to create it from scratch. Right now I am just entertaining to see what others might have done and do not have any specific requirements for how it functions or style of it..............
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
Can you be more specific? If you set up share a workbook or sheet you can use track changes to provide an audit list.
 

JaredMcCullough

Well-known Member
Joined
Aug 1, 2011
Messages
516
Can you be more specific? If you set up share a workbook or sheet you can use track changes to provide an audit list.

Trevor thanks for the reply....my end goal is to build a format that I can create a system to build audit reports in but as this is kind of a broad statement I was wanting to see if anyone had something already in place that could maybe be adapted to more of what I was looking for. I would like to be able to generate various company audits using the same system....maybe if you could explain a little more about your technique I could better determine if it would apply?
 

JaredMcCullough

Well-known Member
Joined
Aug 1, 2011
Messages
516
Can you be more specific? If you set up share a workbook or sheet you can use track changes to provide an audit list.

Another way to look at it would be a way to easily enter a set of data...(The audit questions and references) into a worksheet then have a second step to enter the outcomes after the audit was performed for each of the questions.....then have a final way to translate deficiencies to a separate worksheet...I guess my initial reaction was to see if anyone had already established a Audit system in excel and from there if not I will try to build it piece by piece based upon my desired outcomes.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,601
Messages
5,625,749
Members
416,133
Latest member
ToseSenpai

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top