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 anyon...
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