VBA/Macro to export one sheet

[fat controller]

Is there a way to have a bit of code or a macro in Excel to export one sheet only, with formatting, to a new/blank database, and then save that new sheet as a specified string to include the name of the sheet it originated from?

 

[Trevor G]

Sorry no one seems to have given you a solution but have you found a solution?

If not you can do something like this:

Sub CopyAndSave()
'Change the sheet name
    Sheets("Play").Copy
'Save the workbook
ActiveWorkbook.Save
'What do you need to do next
End Sub