I would create the excel file as a template with a Raw Data tab that feeds your formula tabs and Pivot Charts or tables. A bit of C# can copy,...