Sequential Job Code Generation

[Sir Spike]

I know how to make excel automatically insert todays date into a certain cell when I put a little x in a tick box, but how can I make it insert a sequential number?

I thought of counting the number of boxes that have been ticked so far to give me a new sequential number, but this won't work.

You see, I want excel to automatically create a fresh job number when the tick box is marked. The job number (or job code) consists of a two-letter identifier, the year, and a 2-digit sequential number.

For example: CC-07-01, SV-07-01, PL-07-01

The first two-letters are inputed manually, but the last two must be the next sequential number which is available for that code, so that no two are the same.

When I input 'CC', then tick the box, the job code CC-07-01 should be generated.

When I input 'CC' and tick the box again, the job code CC-07-02 (the next number in sequence) should be generated, and so forth.

However, when I input 'SV', then tick the box, the number should go back to the start (as this is the first job for SV): SV-07-01

If I create a table with all of the job codes in sequence (e.g. CC-07-01, CC-07-02, CC-07-03...), and a seperate column for all of the different two-letter identifiers, can I get excel to automatically pick the next code in sequence when I input 'CC' and tick the box?

[BigBas]

Without seeing your worksheet, I cant give you an exact answer. Try incorporating this formula with your layout:

=A1&"-"&YEAR(TODAY())&"-"&COUNTIF($A$1:A1,A1)