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.
14 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹5535
Dear customer, I have good skills in typing. I can finish your project in low cost within the specified time. so I request u handle the project to me. Waiting for your reply
data entry, excel work and for other related works, we can discuss the open positions in more detail, and you can ask any questions you may have
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