I have a spreadsheet that I updated and changed a lot of the formatting. The people who use it want to copy their old information over (it's a lot) and it needs to take the formatting of the destination cells in the new workbook. They don't know how/don't want to use "paste special" for everything, because it would take a lot of time. Is there a way to have it automatically take the format of the destination cells on a regular Copy & Paste?
Bookmarks