Excel 索引目录

加

name=索引目录

[Formulas]-[define name]=INDEX(GET.WORKBOOK(1),ROW(A1))&T(NOW())

sheet【B1】=IFERROR(HYPERLINK(索引目录&"!A1",MID(索引目录,FIND("]",索引目录)+1,99)),"")

 

https://jingyan.baidu.com/article/414eccf6681ddf6b431f0aea.html