Claus Buschæ–¼ 2015å¹´1月31日星期å…* UTC+8下å�ˆ9時15分40秒寫é�“：

Thanks Claus, sorry to botther you again how to create indices for these sheets?


sorry, my translation was wrong.
Try:
=INDIRECT("Sheet"&MID(CELL("filename",A1),FIND("Sh eet",CELL("filename",A1))+5,99)-1&"!RC",0)+1


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional