Hi
My CRM requires 20 fields (of its 50+ fields) to have data complying only to certain lists-of-values (LOVs).
Most LOVS are only a few options except one has 250.
Sometimes LOVs and schemas change as I run several CRMs.
How can I use Excel to 'test' my import data and identify fields that violate the LOVs.
So I can have them edited.
Each import file can be upto 10K rows.
Am open to turning this into a commercial job for someone who can help.
TDD
Bookmarks