Hi Everyone,

I have a mini invoicing system and I would like to insert invoice numbers
that would increment automatically.

At the moment I am using this formula:=IF(K100,'01'!L7+1,"")

'K10' is the cell I insert the date in so I can see the invoice number only
after I insert the date. At the moment I am using about 300 workshets but I
can not find a way of how to copy the formula and changing the previous sheet
number.

Any help will be greatly appreciated

Thanks
Albert