Automating the generation of a number

Hi,

So I didn't have notifications set up which is why I never responded since a year ago. Anyways, this is what I'm trying to do.

We have a sheet that tracks a long list of film projects. The rows are moved up and down the sheet depending on what stage of development they transition into. We set up unique project codes for each project when they need to be set up in Accounting for payments. I need to be able to check a box in a row for a project when it is time to create the projects code (ie PROJE0001). But I need the system to work so that when I check a different project's box further down the list it gets a new code with a sequential number (ie PROJE0002). If I check yet another box at the top of the list above the other two checked boxes that project's codes should have the next number sequentially (ie PROJE0003). Then I need the codes to be locked regardless if the project name changes or the project moves to a different row. The number in the code should be based on when (ex the date/timestamp) the checkbox is marked.

I hope that helps explain things. If not, I'll try again.

Please let me know if you have any thoughts on making this work.

Thanks!