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.