I am creating an order form in Excel and save as a template. In this template which contain an order number in cell G1 and the initial number is 1000. I want this number to be automatically increased by 1 every time I open through FILE/NEW. And the template will contain the number (1001...) for the next user.
I think you will come up some great idea to handle it.