Macro to save form as new worksheet in the same workbook

[cecilsimon91]

Hi there,

I am currently working on a form on excel wherein, once you fill it in, you can save partial data onto a summary sheet (in that same workbook) and have a complete copy of the form saved elsewhere as a PDF. However, is there a macro to allow me to save the complete form (as it is) onto a separate excel worksheet? Could this macro further allow me to rename the sheet after it is saved?

Thanks in advance