asked on

Data validation checks - Automated rules driven

Guys/Gals, would any of you know of any tools/methods out there which would allow me to list some validation rules, all within Excel?

e.g. no blanks for column N
e.g. if column X="Y" then column Y must not be blank

etc etc

Ramanhp

Hi,

plz check the attachment
Book1.xlsx

Runrigger

ASKER

Ramanhp, thank you for the response, I should have been very clear in my request however;

Using the Data-Validation options is not an option as I will need to run the desired rules against a set of data which is provided to me, generating a list of issues as the validation checks are run and trapping errors.

basically, my team has been handed a process which has a check list of about 80 validation checks, its now almost midnight in London and I am still in work going through them!!!!!

This should be a process which takes about 10 seconds for a VBA program to run through, not 2 hours performed manually!!!!

I can write one for sure in VBA, I just wondered if there was one out there already?

ASKER CERTIFIED SOLUTION

zorvek (Kevin Jones)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Runrigger

ASKER

Kevin, I was afraid that you would say that.

I have my own ideas and will probably pursue those, but as you are part way through the process already, at a very high level, what is your approach to this?

Runrigger

ASKER

Thank you Kevin, apologies for the very late response.

Didn't quite offer what I was hoping but a correct response nonetheless