Quote Originally Posted by NBVC View Post
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