I have a master workbook that crunches data into three worksheets (All same workbook) via power queries, data modeled columns in power pivot, and some formulas.
I currently use VBA to archive and save this workbook with each update however the archived files still contain all of the formatting, formulas, queries, pivots, etc. This makes the files, in some cases, very temperamental to work with .
My goal would be to save Sheet 1 to the new workbook as values only. Sheet 2 Ranges A:H would be formats & values, Sheet 2 Range I:CK would be Values Only. Sheet 3 would follow same format as Sheet 2.
Then I want to save this new workbook to the desired path and rename using my defined naming convention.
Can anyone assist?
I currently use VBA to archive and save this workbook with each update however the archived files still contain all of the formatting, formulas, queries, pivots, etc. This makes the files, in some cases, very temperamental to work with .
My goal would be to save Sheet 1 to the new workbook as values only. Sheet 2 Ranges A:H would be formats & values, Sheet 2 Range I:CK would be Values Only. Sheet 3 would follow same format as Sheet 2.
Then I want to save this new workbook to the desired path and rename using my defined naming convention.
Can anyone assist?
