#1
|
|||
|
|||
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 |
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 |
Exporting Resource Usage data to Excel | samg54 | Project | 1 | 08-02-2013 05:28 AM |
Macro: Exporting Data to a LEGIBLE Excel Spreadsheet | jeffcoleky | Word VBA | 6 | 05-08-2012 08:24 AM |
* 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 |