Hi All,

My question is, how can I auto increment numbers across multiple worksheets.

I have 22 worksheets each sheet has 8 columns, Column A would be the column that when filled (With Text) would generate an auto number in column H2.
now this needs to happen no matter what sheet I enter data into, the Auto numbers would be added. Preferably I would like a format like: rcp-00001

I also have a userform that loads when the work book opens, this userform has 22 tabs (multi tab page), each tab has text boxes and a combobox, this are populated from each work sheet.
so I guess this needs to be taken into consideration for code, as I could end up with ambiguous name. From the userform I can fill the textboxes and save to the corresponding sheet.
so I already have quite a bit of code going on. All of my worksheets have there own name, although I don't think this matters as they can still be refered to as Sheet1, Sheet2 etc etc.

so in a nut shell if I enter data into sheet1 starting at A2 across to F2 this would auto generate a number in H2 ie (rcp-00001)
then if I entered data into sheet 12 at A2 to F2 it would generate a number in H2 ie (rcp-00002)

I hope my explanation is understandable.
thanks for any advice or help in advance.