Auto Numbering formula

**mpoojary** · 09-06-2011, 08:30 AM

Hi,

I have a workbook named Invoice this workbook has multiple worksheets. I require a formula to do the following.

In Sheet 1, Cell B2 =1
In Sheet 2, Cell B2=2
In Sheet 3, Cell B2=3
In Sheet 4, Cell B2=4

and so on.

Right now I am manually adding the sheets and renaming them to say 001, 002, 003 and so on. The Invoice no in B2 is also equal to the Sheet name.

Thanks In advance

Mahesh Poojary

**NBVC** · 09-06-2011, 08:37 AM

This formula in B2 of each sheet will give you the respective sheetname.

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)

if you want the result to be an actual number, add +0 to the end of the formula to convert it.

**mpoojary** · 09-06-2011, 08:53 AM

Originally Posted by NBVC

This formula in B2 of each sheet will give you the respective sheetname.

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)

if you want the result to be an actual number, add +0 to the end of the formula to convert it.

Hi,

I tried your formula but it doesnt seem to work. Please allow me to rephrase my question.

I have a workbook named Invoice. This contains multiple worksheets. The worksheets are renamed as 001, 002, 003, 004 and so on.

The cell B2 of every worksheet should be equal to the worksheet name

Thanks Once again.

Mahesh Poojary