{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["January","February","March","April","May","REPLACE, FIND","VBA","Semi_Dynamic","Overview"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"January","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of January"]
[]
[null,"Date","Product Code","Product Name","Sold Amount"]
[null,"2022-01-05","AC048","Air Cooler",1200]
[null,"2022-01-14","LP89","Lamp",45]
[null,"2022-01-15","TM71","Trimmer",60]
[null,"2022-01-18","SR24","Stabilizer",150]
[null,"2022-01-25","WP346","Water Purifier",280]
[null,"2022-01-26","TF287","Table Fan",340]
[null,"2022-01-28","BR193","Blender",780]
[null,"2022-01-29","RC731","Rice Cooker",180]
[]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"January"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"February","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of February"]
[]
[null,"Date","Product Code","Product Name","Sold Amount"]
[null,"2022-02-08","ST146","Smart TV",2400]
[null,"2022-02-10","PB254","Power Bank",60]
[null,"2022-02-12","SR24","Stabilizer",150]
[null,"2022-02-13","BR193","Blender",780]
[null,"2022-02-17","AC048","Air Cooler",1200]
[null,"2022-02-22","WM327","Washing Machine",1800]
[null,"2022-02-25","RC731","Rice Cooker",180]
[null,"2022-01-26","SW919","Smart Watch",350]
[]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"February"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"March","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of March"]
[]
[null,"Date","Product Code","Product Name","Sold Amount"]
[null,"2022-03-01","LP89","Lamp",45]
[null,"2022-03-04","BR193","Blender",780]
[null,"2022-03-08","ST146","Smart TV",2400]
[null,"2022-03-10","WM327","Washing Machine",1800]
[null,"2022-03-18","TM71","Trimmer",60]
[null,"2022-03-23","SW919","Smart Watch",350]
[null,"2022-03-25","BR193","Blender",780]
[null,"2022-03-26","AC048","Air Cooler",1200]
[]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"March"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"April","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of April"]
[]
[null,"Date","Product Code","Product Name","Sold Amount"]
[null,"2022-04-02","AC048","Air Cooler",1200]
[null,"2022-04-05","TM71","Trimmer",60]
[null,"2022-04-06","TF287","Table fan",340]
[null,"2022-04-09","PB254","Power Bank",60]
[null,"2022-04-13","WM327","Washing Machine",1800]
[null,"2022-04-15","RC731","Rice Cooker",180]
[null,"2022-04-16","BR193","Blender",780]
[null,"2022-04-19","ST146","Smart TV",2400]
[]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"April"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"May","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of May"]
[]
[null,"Date","Product Code","Product Name","Sold Amount"]
[null,"2022-05-03","BR193","Blender",780]
[null,"2022-05-09","ST146","Smart TV",2400]
[null,"2022-05-14","SW919","Smart Watch",350]
[null,"2022-05-15","AC048","Air Cooler",1200]
[null,"2022-05-18","TM71","Trimmer",60]
[null,"2022-05-22","WP346","Water Purifier",280]
[null,"2022-05-24","RC731","Rice Cooker",180]
[null,"2022-05-25","ST146","Smart TV",2400]
[]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"May"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"REPLACE, FIND","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,1,12,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
[]
[null,"Combining GET.WORKBOOK, HYPERLINK, INDEX, REPLACE, FIND, T, and NOW Functions"]
[]
[null,"Table of Contents"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A1))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A1))),\"\")","v":"January"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A2))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A2))),\"\")","v":"February"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A3))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A3))),\"\")","v":"March"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A4))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A4))),\"\")","v":"April"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A5))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A5))),\"\")","v":"May"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A6))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A6))),\"\")","v":"REPLACE, FIND"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A7))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A7))),\"\")","v":"VBA"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A8))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A8))),\"\")","v":"Semi_Dynamic"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A9))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A9))),\"\")","v":"Overview"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A11))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A11))),\"\")","v":""}]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"REPLACE, FIND"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]
[]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(Dynamic_Table_of_Contents,ROW(A16))&\"'!A1\",INDEX(Dynamic_Table_of_Contents,ROW(A16))),\"\")","v":""}]

{"sheet":"VBA","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[11,1,11,2]]}
[]
[null,"Embedding VBA Macro"]
[]
[null,"Table of Contents"]
[null,"January"]
[null,"February"]
[null,"March"]
[null,"April"]
[null,"May"]
[null,"June"]
[null,"REPLACE, FIND"]
[null,"Semi_Dynamic"]
[null,"Sheet2"]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"VBA"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"Semi_Dynamic","index":7,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Using Formula to Create Semi Dynamic Table of Contents"]
[]
[null,"Table of Contents"]
[null,{"$f":"HYPERLINK(\"#'\"&C5&\"'!A1\",C5)","v":"January"},{"$f":"_xlfn.VSTACK(January:Semi_Dynamic!C15)","v":"January"}]
[null,{"$f":"HYPERLINK(\"#'\"&C6&\"'!A1\",C6)","v":"February"},"February"]
[null,"March","March"]
[null,"April","April"]
[null,"May","May"]
[null,"REPLACE, FIND","REPLACE, FIND"]
[null,"VBA","VBA"]
[null,"Semi_Dynamic","Semi_Dynamic"]
[null,0]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"Semi_Dynamic"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]

{"sheet":"Overview","index":8,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Overview of Dynamic Table of Contents in Excel"]
[]
[null,"Table of Contents"]
[null,{"$f":"HYPERLINK(\"#'\"&C5&\"'!A1\",C5)","v":"January"},{"$f":"_xlfn.VSTACK(January:Overview!C15)","v":"January"}]
[null,{"$f":"HYPERLINK(\"#'\"&C6&\"'!A1\",C6)","v":"February"},"February"]
[null,"March","March"]
[null,"April","April"]
[null,"May","May"]
[null,"REPLACE, FIND","REPLACE, FIND"]
[null,"VBA","VBA"]
[null,"Semi_Dynamic","Semi_Dynamic"]
[null,"Overview","Overview"]
[]
[null,"Sheet Name",{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",C15),\"]\")","v":"Overview"}]
[]
[null,"Jump to Table of Contents Worksheet","Table of Contents"]