I have a workbook with three tabs. I would like to create a macro for a command button that will create a duplicate workbook named "Current Month, Current Year" and copy+paste values for all information in the host workbook. Essentially I want to create an identical workbook with all the same labels and move the data over so the formulas are no longer in play. Is this possible?
A Macro to Create New Workbook and Paste Values Only