In the attached workbook I'd like the fastest code that will create Sheet2 as a transformation of Sheet1, retaining Sheet2's headings. Sheet2 should have the same colors as Sheet1. I have code that does it but it's very slow. Note that Sheet1 has data for two weeks while in real life there are more than 500 weeks.