I am working on a business spreadsheet, and I was wondering, is there a way that selected cells can be programmed to reset at certain intervals?
So on a particular form, there are details of order numbers etc, but, would it be possible for excel to automatically reset the order numbers on a monthly basis?
I am using Excel for Mac 2011
Thanks in advance for your help.
Bookmarks