audit

I have 2 workbooks that I need to copy a worksheet from one to the other and still maintain formual integrity. All of the sheets are identical in both workbooks. There is 1 sheet that needs to updated on a per job (leak audit) basis. That sheet is called flow rate. The flow rate sheet has...

Hi All, Thank you in advance, what i need is to be able to highlight the difference between 2 worksheets in the same workbook, fig1 below is sheet1 and fig2 is sheet2. <colgroup><col span="2"><col><col span="2"><col><col><col></colgroup><tbody> fig1 fig2 DEC JAN Desc...

Hi all, I currently have a spreadsheet with multiple sheets within it. Each sheet represents a work centre. Each sheet contains the dates that a number of tests have been completed. I currently have a separate audit spreadsheet that calculates the difference in dates between each consecutive...

Hello, I am having an issue with my audit trail. It works perfectly, however I was told that only edited and deleted records will need to be kept in the audit trail. New records do not need to be in the audit trail. As I attempted to manipulate my code to exclude new records, I've noticed...

Okay, It sure seems like this should be simple. I've got an entry form, where the user will enter audit information. If the score for the audit is less than 100%, then they need to enter a reason for the failure. However, the code below will still pop the message even if the score is 100%...

Hi Folks, I'm relatively beginner and new to this forum. and appreciate if could help me to get the coding idea How to Log Audit trail of a particular cell or cells of a WorksheetSay I have a workbook where i have worksheet "Sheet1" where the records are displayed as indicated below. <tbody>...

I AM NEW TO EXCEL AND I AM HAVING TROUBLE WITH A WOOKSHEET I CREATED. ON ONE SHEET I HAVE A DATA PAGE (TABLE) WITH 19 COLUMNS OF DATA. ON SHEET 2 I AM TRYING TO SET UP AN AUDIT PAGE WHERE THE USER CAN HAVE A DROP DOWN MENU OF THE 19 COLUMNS OF DATA FROM SHEET 1 AND BE ABLE TO SELECT WHICH...

Hello, I have the below code to use Workbook (UMROI_Standard Cost Audit Reports.xlsm) Worksheet (Account To Component Audit) and clear the data from Row 9 & Column A to F all the way to the last row. I then open up my source Workbook(ent_component_audit_umroi.txt) Worksheet...

Good Morning, I am putting the final touches on my macro and have two issues I need help resolving. 1) I need to create a IF to a row delete since when there are no rows to delete I get and error. here is the line of code. Range("A7:A" &...

Hello, I have developed this code to perform the task of copying data from one workbook into another and being able to adjust for more or less rows. So far from help here I have gotten nearly to my desired result. The two issues I am having is (1) If the Previous data that is getting cleared...

Hello, I have put together the following code for my table however I need to figure out how to include a SUM row at the bottom. Any assistance will be appreciated. Workbooks.OpenText Filename:= _ "K:\1900\dwprod1900\data\export\general\before_n_after_remap_audit_umroi.txt", _...

Hi, I have had help in earlier threads but kind of caused confusion with what I was asking so I started a new thread to properly ask for assistance. I have created this macro below which has accomplished my desired task of copying data from one workbook into another, however, I need to figure...

simply put, I'm trying to create a macro VBA to copy a line of data in one work book and paste it into a central recording WB on the next empty line This macro will be put onto a number of documents (all the same) which are audit documents that record scores. Then I click a button and it will...

I am trying to write a code to send Outlook meeting invites based on what I have in a spread sheet. I am missing several key points in the code so decided to see if anyone out there can develop one that works better than the mess I created. Below is the type of spread sheet I will be using...

Hello, I need some help using conditional formatting. I have a spreadsheet with employee payroll data. In column A I have a formula that numbers the row. I did this, so that when I filter the data based on salary amount over a $ threshold, I could have a numbered list. The formula that I have...

My end users enter data in the sheet for a batch, then they press a button to run code, check for certain errors, then lock the cells. Audit trail is populated with Date, Time, Excel User ID, Batch Number, worksheet tab. Sub AuditTrail(batchnumber As String)...

Cross-link: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/954352-bug-re-formula-auditing-tables-listobjects-known-ms-since-2007-a.html I'm reporting a bug re formula auditing with Tables (ListObjects). Just follow these steps in Excel >=2007: 1.Start from a blank...

Hey guys so with my current job I've been asked by my boss to do an audit of all the PC's in our office. About 300 or so. Mainly just need to list all the basic details like the make and model, location, operating system, hardware specs and software installed. He want's it in an excel...

Hi Guys, I have been trying to create a VBA change log for days now, without any luck whatsoever. I have a workbook that contains several sheets, and I want to log every change that is made to a cell within the workbook The information I want to log: Username (excel username), Date, Time...

Hello Everyone. Hope you had a good thanksgiving! So this is something I do each month. It's all done in VBA except for 1 aspect which I have trouble fathoming how one would even go about coding. So for now, I do it manually :mad:. This is a small example of the data...