So I'm having a slight issue with the current workbook I have for Excel.
As it states, when all the required information is inputted in the required highlighted fields and by clicking on the Print Form option, it generates an Invoice number with a specific format of YYDDDDhhmmss
What I'm trying to do is change the code around so when a user opens the document, an Invoice number automatically generates in the appropriate box without having to click the Print Form button to generate such Invoice number. I've looked around for such viable options but all I was able to stumble across were simple numbers like 001, 002, etc... For this though, it has to remain the same format as listed above.
Now with my knowledge, I've have some when creating macros and such but never has been my strong key point in the IT world, least with excel it ranges from a 4-6 easily. What I'm asking is if someone can overlook the sheet I have and advise me as to what codes should be changed and as to what exactly.
I would greatly appreciate it!!