R
R Guzman
All, I'm creating an Invoice and I need to generate a unique Invoice number.
It can be something like, "(Today's Date) + "String" + (Sheet Number) or
something like this.
Problem is Date Function always updates once I open the file. Secondly I
need a unique id (number) to append to the date that can be incremented once
I create a new sheet.
Finally, I need to convert this to a text valve that doesn't get updated.
Anyone had a similar need and come up with a working solution?
Thanks.
It can be something like, "(Today's Date) + "String" + (Sheet Number) or
something like this.
Problem is Date Function always updates once I open the file. Secondly I
need a unique id (number) to append to the date that can be incremented once
I create a new sheet.
Finally, I need to convert this to a text valve that doesn't get updated.
Anyone had a similar need and come up with a working solution?
Thanks.