I have a macro which breaks up a master spreadhseet based on the value of column A. When run the macro splits the master sheet into new files based on column A. The issue I have is that the master sheet contains formulas which when the macro is run the split files contain only the values.
Please can you advise if there is any code which will ensure the formulas are kept, the cell range of the sheet is A to AF. Also, is it possible to have the output files expand the column widths to fit the data held in the file?
For information, there is a code line which reads "ActiveSheet.Cells(2, 2).Value" which is the only reference I can see to possibly pasting the values of the master sheet.