Save Worksheet to New Excel File

Hi Everybody,

Thank you everybody for your help so far.

I currently have a worksheet called 'invoice' and I would like to have a button on this sheet which will export the worksheet to a new workbook and then save it.

Each invoice is unique so I would like when the button is clicked to save the invoice with the invoice number included in the file name. I would effectively like to save a new invoice with a new filename so I will have various invoice files. The format will obviously be xls.

I was also looking to create a button which will print the invoice as well.

Is there a macro I can apply to buttons to achieve these?

If you have any suggestions, they would be greatly appreciated.

Kind regards,

Brown Teddy Bear