save as and update workbook

G'Day

I'm in the process of making a Quote form in workbook named MASTER, when the quote is finished i want to save as the quote number in sheet "quote" range H3 this part i have sorted, i want to default back to the master workbook and then update the quote number by 1, range H3 + 1 then save the master copy. closing the newly saved as workbook,
this is what i have so far, it updates the quote number in the new workbook.

Please Login or Register  to view this content.

Use "ThisWorkbook.SaveCopyAs" instead of "ThisWorkbook.SaveAs". This will create a copy of Master but leave Master alone.