Hi,
I'm trying to set rules up in an excel so that when data is pasted into the cells, if it's incorrect it won't allow the user to paste the data. However, it seems that when i set the rules up and paste the data, it just completely removes the data validation rules. Is there a way round this?
Thanks
Bookmarks