Match Destination Format
 

Dear,

I have a spreadsheet where I would like everything I paste into to it to
match the formattting of the cells around it and not retain the formatting it
had in its original location.

And also it should validate the data copied to the particular cell and throw
the error notes if it does not match the validation notes created.

Also the data copied is replacing the drop down list mentioned in a cell.

Please suggest on this.


I don't want to have to select "match
destination formatting" every time--I want it to default to that. Any ideas?
Thanks.