Hi Team,
I have an FTE Template used for entering the hours of all full time employees . In that template we have one column called Resource Designation. I have a put a data validation for this with the list of 3 values Manager,Clerical and Professional.
Clients are facing one issue , whenever users are copy/pasting the values from another excel sheet into this template, data validation is not happening and its taking the wrong values like Management instead of Manager also as correct value.
Is there any way to prevent this pasting from another workbook so that data validation works fine.
I am attaching a sample file fte.xlsm but not the original file.
Please help me in resolving this issue.
I have an FTE Template used for entering the hours of all full time employees . In that template we have one column called Resource Designation. I have a put a data validation for this with the list of 3 values Manager,Clerical and Professional.
Clients are facing one issue , whenever users are copy/pasting the values from another excel sheet into this template, data validation is not happening and its taking the wrong values like Management instead of Manager also as correct value.
Is there any way to prevent this pasting from another workbook so that data validation works fine.
I am attaching a sample file fte.xlsm but not the original file.
Please help me in resolving this issue.