Match Destination Format

S

Sasikiran

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto match destination formatting for Mac 0
Word macro that can call cells out of Excel for a find and replace 0
Create a dynamic master file 1
Match Destination Formatting 2007 0
Print (physical or pdf) not respecting format of source document 0
Match Copy/Paste Macro almost there 0
Automatically match destination formatting? 3
excel partial match 0

Top