Need to write an excel macro for complete validation of all fields for the data in a sheet.
Pls check the attached sheet. If you see few of the individual fields they have separate data validators ( You need the password to check the individual field validations - pls ping me for details).
I want this validation to be done for all the rows in case some one cuts and pastes multiple rows of data.
I want this validation to be triggered on clicking a validate button somewhere in the sheet
The fields withe validation are as follows : Email, Location, Phone, Qualification, Competency, Primary & Secondary skill, Industry, Project Exp,TE years, TE Months, RE Months, Aval_From
You can highlight the errors by marking the cell in red. Once the sheet is validated you need to set value as 'Validated : Yes' in another cell in a separate column. Once the sheet is edited again you can set the value back to 'Validated:No'
I also want you the check for Mandatory fields. All fields highlighted in red are Mandatory - you need to highlight the relevant cells and set the "Validated:Yes" field only if all fields are filled in.
I also want the 'Validate' button to be placed in the blue area on top besides the logo.
13 freelancers are bidding on average ₹5826 for this job
I am a experienced python programmer. I can design a nice script to validate whatever data you want and display the errors on a dialouge box as well as in excel or in any form you want