excel自动生成目录
点击【公式】—选择【定义名称】，输入公式=GET.WORKBOOK(1)
输入公示生成目录
=IFERROR(HYPERLINK("#'"&MID(INDEX(menulist,ROW(1:1)),FIND("]",INDEX(menulist,ROW(1:1)))+1,99)&"'!A1",MID(INDEX(menulist,ROW(1:1)),FIND("]",INDEX(menulist,ROW(1:1)))+1,99)),"")
点击【公式】—选择【定义名称】，输入公式=GET.WORKBOOK(1)
输入公示生成目录
=IFERROR(HYPERLINK("#'"&MID(INDEX(menulist,ROW(1:1)),FIND("]",INDEX(menulist,ROW(1:1)))+1,99)&"'!A1",MID(INDEX(menulist,ROW(1:1)),FIND("]",INDEX(menulist,ROW(1:1)))+1,99)),"")