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
e.g. no blanks for column N
e.g. if column X="Y" then column Y must not be blank
etc etc
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
ASKER
Thank you Kevin, apologies for the very late response.
Didn't quite offer what I was hoping but a correct response nonetheless
Didn't quite offer what I was hoping but a correct response nonetheless
plz check the attachment
Book1.xlsx