This content has been marked as final. Show 3 replies
I solved it.
There is a save as function that with some trial and error I have it setup to a script that creates the spreadsheet and emails it.
Is there a way to save multiple layouts as worksheets in a single Excel file?