热度 1|
=HYPERLINK("#"&INDEX(MID(TRANSPOSE(shtname),FIND("]",TRANSPOSE(shtname))+1,99),ROW(A4))&"!A1",INDEX(MID(TRANSPOSE(shtname),FIND("]",TRANSPOSE(shtname))+1,99),ROW(A4)))&T(NOW())
先得定义一个名称,取得工作簿内所有工作表的名字。
shtname = =GET.WORKBOOK(1,"工作簿文件名")
函数后面的t(now())可以实现即时刷新,即便工作表改名后,内容能自动刷新。