Hi Expert.. I have a sheet, where user have to fill data. There is a column Department.. user should not enter or paste a value other than defined departments. i have applied validation using data>>validation. but it works only if the user selects department from the validation list. but if he copy data from his source and paste it in my Sheet, then the validation doent work. i have created a button (Validation) on the top of the sheet, to validate the data. it validate for email id, contact numbers, name, etc... when the user clicks on this button it throws errors.. the same way it shold throw the error if the department is not in the validation list... please help me out... its urgent
Thanks in advance
Regards
Seema
Thats a lot of form work to be expecting out of Excel. You might be better off using Access, creating a table. If you need to export it back to a spreadsheet you can. The validation controls are better in Access and don't have a lot of limitations to them.
Good luck on that
1,956 views
Usually answered in minutes!
×