Spreadsheet to Generate and Track ISRC Numbers With a Single One Click Button To Generate Next Number In The Sequence

[deciongroup]

Hello,

I am [very much] a novice with macros and buttons so I am reaching out for [any] help for this effort. I started a small sound design business and need to track International Sound Recording Codes [ISRC] which are assigned to all MP3 and other formats of files delivered to my clients.

What I want to do is to simply have a spreadsheet that I will enter project titles and other information into in a given row. I then want a single button [labeled "MAKE NEXT ISRC"] in the center of the top row that when clicked will generate the next number and place that number in a given cell.

For example, [viewing the attached screenshot], I enter the date, the name of who assigned the code, the project producer, and the project title. Then I want to click the "MAKE NEXT ISRC" button and the next number colored blue [starting with QZTDG2000001] is generated in cell C3. The next entry and done the same way, click the "MAKE NEXT ISRC" button and the next number in the sequence fills cell C4 and so on.

Can anyone tell me how this can be done in whole or in part]? I would be grateful.

 

[CSmith]

Just like Leith Ross says:

Add a new VBA Module to your workbook. Copy the code below and paste the macro code into the new module. Assign the macro to your Button.

Same would apply only to my code...

 

[CSmith]

Alternatively you could right click the button you have and assign macro, if you have already added either set of code to your Workbook's code / module area, you can then pick one or hit new and it should let you paste either code set into the created macro minus the "Sub ..." & "End Sub" lines

 

[deciongroup]

You are amazing!!!! Thank you very much. It works perfectly. I am very grateful for your help.