podder
01-14-2018, 04:32 PM
Hi,
Could anybody please help, I have a workbook that generates invoices through a macro and I need these generated invoices to be copied and saved to a new workbook.
I would like the formatting to remain and a msgbox to let me rename the new workbook.
Also, would it be possible to omit 4 worksheets that are permanently in the source workbook (these sheets are not in consecutive order)
Any ideas would be greatly appreciated
Thanks
Could anybody please help, I have a workbook that generates invoices through a macro and I need these generated invoices to be copied and saved to a new workbook.
I would like the formatting to remain and a msgbox to let me rename the new workbook.
Also, would it be possible to omit 4 worksheets that are permanently in the source workbook (these sheets are not in consecutive order)
Any ideas would be greatly appreciated
Thanks