Hi,
I have data validated cells i.e E4:L40 and data allowed is a list in cells Q52:Q80. Data validation is not working when someone c/p and the only VBA code i could find is one that forbids c/p totally. That's not helpful because i want to give editor's permition to c/p if the text, they want to c/p, is from the list (Q52:Q80)
(list and validated cells are not the same in every sheet but if i could find a VBA code i'll be OK)
Any thoughts?
Thanks
I have data validated cells i.e E4:L40 and data allowed is a list in cells Q52:Q80. Data validation is not working when someone c/p and the only VBA code i could find is one that forbids c/p totally. That's not helpful because i want to give editor's permition to c/p if the text, they want to c/p, is from the list (Q52:Q80)
(list and validated cells are not the same in every sheet but if i could find a VBA code i'll be OK)
Any thoughts?
Thanks