Each month I receive an EXCEL spreadsheet, I am been entrusted to scrub the file cleaning up errors before its imported in a CRM.
I haven't used Access in years since our organization deployed CRM and would love some help. My thought was to bring the file into access and develop a few macros. Here are a few basic things I had my sights on.
If [description] contains *Dual* change [quantity] to 2
If [description] contains *Refurbished* and [sku] is ABC123 change [sku] to 321CBA
Next I need to detect duplicates
If [auth number] is duplicated and [first name] is blank delete the row AKA record
Look forward to hearing back from the group, thanks in advance for your help.
R