+ Reply to Thread
Results 1 to 4 of 4

Audit of data in an excel sheet.

  1. #1
    Registered User
    Join Date
    10-03-2017
    Location
    Thatcham, England
    MS-Off Ver
    Office 365
    Posts
    18

    Audit of data in an excel sheet.

    Hi There,
    Hope this is in the right place.
    Im trying to make an audit of data quick and easy to do in excel.
    I have a list of reference numbers in a column, the reference number could be in the column twice or three times.
    Depending on whether its in twice or three times I then want to check the names against the reference numbers match the assigned name in two other columns!
    For the example below, for Ref 531, I want to check Jerry is Assigned Eng 1 and Dusty is Assigned Eng 2.
    Ref 532 I need to check if Jerry is assigned eng 1 and then if Rob or Kevin are Assigned Eng 2.
    If the responsible engineer is not the same as the assigned engineers I need to highlight it as ref 533, Jerry and Dusty DON'T appear in Assigned Eng 1 or 2.

    Ref Responsible Engineer Assgined Engineer 1 Assinged Engineer 2
    531 Jerry Jerry Dusty
    531 Dusty Jerry Dusty
    532 Jerry Jerry Kevin
    532 Rob Jerry Kevin
    532 Kevin Jerry Kevin
    533 Jerry Ray Rob
    533 Dusty Ray Rob

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,135

    Re: Audit of data in an excel sheet.

    try this

    Please Login or Register  to view this content.
    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    To run the Excel VBA code:
    1. Press Alt-F8 to open the macro list
    2. Select a macro in the list
    3. Click the Run button
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-03-2017
    Location
    Thatcham, England
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Audit of data in an excel sheet.

    That works brilliantly Thank You.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,135

    Re: Audit of data in an excel sheet.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Audit Trail Excel 2010
    By dr3twa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2016, 08:20 AM
  2. Automate Excel Audit Sheet to create a Data File
    By excelnovice2308 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2016, 09:05 PM
  3. Audit/Catalog in Excel
    By mikayluh in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 01-19-2015, 05:08 PM
  4. Audit log for data inserted-edited via VBA Forms
    By Raghukumarn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 12:05 AM
  5. Trying to pull 10 percent of data for audit
    By noobexceldude in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2014, 11:40 PM
  6. [SOLVED] VBA to clean and audit data
    By Yg74 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-23-2012, 01:47 PM
  7. Excel Audit Trail?
    By jvest0648 in forum Excel General
    Replies: 1
    Last Post: 12-17-2011, 02:57 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