Re: auto gererated number when sheet opened
I have a form that I wish to make into a template for our customers to fill in. I would like to have the "Purchase Order" field I've created to have a number automatically fill in with a new number everytime they open the template. Then they would do a save as and that number would stay with the saved file. Then when they open the template again it would then generate the next number in succession. Can this be done.
Thanks
Anthony
I have a form that I wish to make into a template for our customers to fill in. I would like to have the "Purchase Order" field I've created to have a number automatically fill in with a new number everytime they open the template. Then they would do a save as and that number would stay with the saved file. Then when they open the template again it would then generate the next number in succession. Can this be done.
Thanks
Anthony