Hello, I have built a quote calculator for a client of mine. However, for some reason I'm completely stumped when trying to generate a unique reference number. I need a new number to appear in the reference cell each and every time the sheet is reopened. I have a button for the client to click confirming their order, which is emailed directly to me. Without the ref it becomes difficult to determine which order is for which job, I only have the date to go by.
Any help would be greatly appreciated. If you need me to explain further please let me know.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!