Hi
I am creating a VB form, which updates a spreadsheet, and as part of this creates a unique reference number.
I want the Ref number to be CUST/YY/unique number
I am struggling to get the year automatically, I have tried a couple of ways but it didnt work. Currently I am using the below...