Iretioluwa Olawuyi
asked on
Data Validation Macro
Dear Experts,
Please I need your support in writing a simplified VBA code that checks data is a range of cells and report data that don't meet a set validation criteria which can be customized based on datatype/category and give an option to transfer the invalid data to a new sheet. The data range should also be customizable.
Please I need your support in writing a simplified VBA code that checks data is a range of cells and report data that don't meet a set validation criteria which can be customized based on datatype/category and give an option to transfer the invalid data to a new sheet. The data range should also be customizable.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great response.
I appreciate your help, however, I will like to request a sample data that can fit into the code structure for me to understand clearly how it works and also apply to the data I need to validate, you can share to my email iretex1@gmail.com.
Thanks again.
I appreciate your help, however, I will like to request a sample data that can fit into the code structure for me to understand clearly how it works and also apply to the data I need to validate, you can share to my email iretex1@gmail.com.
Thanks again.
Hmm,
you should award credit to experts who answered / provided help to your issue.
you should award credit to experts who answered / provided help to your issue.
ASKER
Pardon me pls, Fabrice, I thought I did this before but somehow got skipped.
I appreciate your support.
I appreciate your support.
Please create a GIG project and hire somebody to implement this for you.