A Macro to Create New Workbook and Paste Values Only [Closed]


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?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!