Hello all,

Can the below formula be made to show the previous sheets name in a workbook.

For example in my workbook the sheet tabs are 01.07.09 - 02.07.09. Is there a way if I right click on tab 02.07.09 and copy it into the same workbook giving me tab 02.07.09 (2) that a cell in the copied workbook will show the previous tab name.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
I need to use this as a reference for a formula I'm using in creating a running balance.