Hi Everyone,
I am currently working with a macro that goes through a master spreadsheet and parses the information into much smaller/more targeted categories based off certain criteria. I've gotten the macro to copy and paste everything correctly but the problem is the formatting.
On my master spreadsheet, I have conditional formatting to color certain cells. When I run my macro, it copies the conditional formatting and creates format errors on the other sheet. Is there anyway I can amend my macro to prevent the conditional formatting from copying over?
Bookmarks