Hi All,

I have a formula I am using to try create an auto Tacking Number system

Formula: copy to clipboard 
=IF(C5>0,CONCATENATE("TS-",M5,RIGHT(N5,2),"-","001"),"")


I want the number to appear as the data is logged into "C5"

The end product I am looking for will be "TS-July14-001", Where "M5" is the given month, "N2" is 2014 so I used the right formula to get 14

The last bit is where I am having problems, I would like the last number "001" to have a fill series effect.

Ultimately if this is possible i would then like the fill series to reset to 001 when the month in "M5" changes.

Hope this makes sense, Can provide an example workbook if needed

Regards,
Simon