Auto numbering in multiple sheets

[aidanryle]

Hello,

I have a workbook that has 201 sheets. The first sheet is a summary sheet that has all the data and the rest of the 200 sheets are blank invoices. I would like to auto-add a sequential number in a certain cell in each sheet. Also, I would like to say that this number sequence already exists in the summary sheet, I just want an automated method of linking the same cell in every sheet to a different cell in the summary sheet.

Thanks,

 

[dnorm]

Hi aidanryle

A sheet count is easy enough the formula "=SHEET(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255))-1". I am guessing that you do not wish to count the summary sheet.
This will return the number of sheet it is minus 1 (which would be your summary sheet. This works when copying a sheet also (in case you add more tabs).

As for auto linking of the sheet to your summary cell, I do not have an answer sorry.