Creating a unique reference number

Hi there,

Sorry to launch straight into a query, but I was hoping someone out there might be able to help me, I don't know the first thing about coding, and have reached the limit of my skill...

I have attached my work so far, but I have reached a dead end.... I am creating a logbook to record the booking out of items, and where they go. Each row is a different record, and I need each row to have a unique reference number. The items are booked out to 3 separate locations (London, Birmingham, Scott Wilson) and I will need the ref. numbers to start LDN, BRM, and WIL according to where they have been booked out to, then a non repeating 4 digit number (0001, 0002 etc).

I realise I haven't explained myself too clearly, but any assistance would be greatly appreciated!

Hi Spencer,

That's great, thank you! Is there any way to make it work so that when I use the 'booking form' to enter the details? If I cancel the booking form at enter manually it works great, but if I use the booking form to enter the details, once I press enter the data is inputted in the first row where there is no formula in the A column... (ie at the very bottom of the spreadsheet)

Would it help if I posted the code from the booking form? If I created some additional code, could the reference number be created that way?

Sorry for being quite so dense, I really have no idea what I'm doing!

Woohoo! Thank you Norie!