日志

Hyperlink应用-超链接跟踪功能: hwc2ycy 2012-8-7 11:59; =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())可以 ...; 个人分类: 函数|1637 次阅读|0 个评论热度 1

GMT+8, 2024-4-29 10:15 , Processed in 0.208506 second(s), 5 queries , Gzip On, Yac On.

		自动登录	找回密码
密码			注册