Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2022, 04:33 AM
tdeogburn tdeogburn is offline Using Excel to Audit Data Responses (IF and THEN identify wrong answers) Windows 10 Using Excel to Audit Data Responses (IF and THEN identify wrong answers) Office 2016
Novice
Using Excel to Audit Data Responses (IF and THEN identify wrong answers)
 
Join Date: Jan 2022
Posts: 5
tdeogburn is on a distinguished road
Angry Using Excel to Audit Data Responses (IF and THEN identify wrong answers)

Hi There!
I am trying to solve a problem, and I need your help! I oversee an office that has many users doing different functions in one single database. Auditing this data to ensure accuracy has always been a challenge. I am hoping to export the data into an excel spreadsheet and use 'rules' about data responses to highlight known entry discrepancies.

For example, I know that if a record has a certain employer listed, the response for who covers that employees insurance should be a specific response. So if employed by Smith Company (column A) the Insurer needs to be Smith LLC. (column B).

I assume that this is going to be some version of a IF THEN statement, but I do not want the cells to fill, I want to draw attention to cells that do not meet my known rules. HELP???

Last edited by tdeogburn; 01-25-2022 at 12:34 PM. Reason: Change Title
Reply With Quote
Reply

Tags
discrepancies, if then, macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting data to an excel template Stevie23 Excel Programming 3 04-05-2018 12:12 AM
Using Excel to Audit Data Responses (IF and THEN identify wrong answers) Exporting Resource Usage data to Excel samg54 Project 1 08-02-2013 05:28 AM
Using Excel to Audit Data Responses (IF and THEN identify wrong answers) Macro: Exporting Data to a LEGIBLE Excel Spreadsheet jeffcoleky Word VBA 6 05-08-2012 08:24 AM
Using Excel to Audit Data Responses (IF and THEN identify wrong answers) * Exporting Access Data to Excel djreyrey Excel Programming 1 03-23-2012 10:03 PM
Exporting many Word files to a database or Excel Mdalu Word 0 05-23-2011 02:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft