Good morning,
I have a spreadsheet that I'd let to set up with a Command button on one sheet that will open a Save As dialogue box for a new spreadsheet and then copy data from another sheet to the new sheet when being saved.

Thank you
Jim