Avatar of Betsy Rempel
Betsy Rempel
 asked on

Paste Special - Match Destination Formatting

I'm a grant writer, and I frequently export data from a grants tracking database into Excel. I have to reformat the sheet so that I can share the report with colleagues. I don't want to have to reformat the data each time I export. I set up a template, which has the headers I want for each column, and I formatted the cells which will contain numbers to a specific accounting format (no dollar sign and 0 decimal places), and in another column, I formatted the cells to present data as a percentage instead of decimal. When I cut and paste from the exported file to the template, it uses the source formatting. I want to match the destination formatting, but that option isn't included in Paste Special if I right click in the template file. I put the Match Destination Formatting icon into the Quick Access bar, but it is greyed when I try to paste, so I can't use it. The icon is active when I first open Excel, it greys out when I select cut. I've attached a file with two tabs - the exported data and the template. Any ideas of how to move the exported data into the template and match the destination formatting?  Thanks!
Example-Worksheets.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Betsy Rempel

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Betsy Rempel

ASKER
Thank you! Its seems so simple once you know the answer.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck