Forum Discussion

horsteadjim's avatar
horsteadjim
Copper Contributor
Jul 27, 2017

MS Excel

I have created a spreadsheet to QC Maintenance Plans. I would like to save each one as another sheet in the same workbook. I have created a button and need to assign a macro to that button. Can anyone help me with the code to save that sheet as a sheet within the same workbook.

Macros & VBA
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Aug 04, 2017
    Sub Test()
    For Each Sheet In ThisWorkbook.Sheets
        'Copy Entire Sheet and Paste ss new sheet in same workbook
        Sheet.Copy After:=Sheets(Sheets.Count)
    Next Sheet
End Sub

Resources