Generate unique ID's with a common prefix

Hi All,

I have a spreadsheet with multiple tabs. I want to create a unique ID which can be a simple number sequence but needs to have a prefix appended to it based on a project acronym. So, something like this:

MDZ001 where MDZ is the prefix I can declare in a cell on the first sheet and 001 is the first number in sequence

I need to make sure that the ID's are unique for all tabs, so I don't want to see MDZ001 on any other tab, i.e. the source for ID creation needs to be central to each spreadsheet.

I'm going to go away and see if I can fix myself, but I thought I would preempt me being a dullard and ask you peeps first!

Cheers

Matt

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.