{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["United States","France ","Canada","Mexico ","Australia ","Finland","Using Hyperlink Function","Using Context Menu","Combined Formula","Using Power Query","Table of Contents"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"United States","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in United States"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",10502,7742,10769,11835,6293,10937,11744,6811,6813,10266,9458,7842]
[null,"Product 2",10218,10026,10269,11633,8491,10008,8589,7417,7235,8700,7000,11916]
[null,"Product 3",9109,11024,7749,8099,6171,10326,9295,8323,11418,10800,9876,9067]
[null,"Product 4",10634,8813,10012,11632,8975,6593,9226,8799,11830,9344,6686,7805]
[null,"Product 5",8053,10483,8702,7541,6457,7474,11711,11090,11266,8285,8617,6731]

{"sheet":"France ","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in France"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",4439,6235,6634,6892,5994,6875,6128,5232,5412,4726,4260,4267]
[null,"Product 2",6627,4027,4049,5113,5957,6213,6101,5961,6286,5718,6255,6299]
[null,"Product 3",5374,5147,6543,5765,6312,6007,4904,6649,5151,6323,6427,5579]
[null,"Product 4",5666,4021,4174,6446,5125,5925,5863,6034,4015,4089,6548,6410]
[null,"Product 5",6215,5606,5879,4645,4375,6290,4089,4648,5212,4469,4556,4774]

{"sheet":"Canada","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in Canada"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",6690,7825,6747,9138,7395,8029,7343,7775,7014,8063,8087,8066]
[null,"Product 2",9487,7489,7370,8046,8898,8163,7156,7145,8861,8511,6515,7846]
[null,"Product 3",6887,7782,8011,9361,8817,6604,7275,7273,6939,6534,8029,8502]
[null,"Product 4",6813,7363,6606,6853,7688,7875,7028,8652,8754,7739,6542,7266]
[null,"Product 5",9094,6826,8775,7725,8188,7659,7562,7085,8117,6674,7717,6677]

{"sheet":"Mexico ","index":3,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in Mexico"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",5697,6764,5857,5675,7288,7647,7308,6140,8776,7323,8872,7866]
[null,"Product 2",5353,7136,8077,8620,7010,7492,8069,7197,7040,6131,6225,6765]
[null,"Product 3",7765,5110,6647,8143,7964,5691,7018,7069,6648,8199,8206,7873]
[null,"Product 4",7106,8133,6168,6426,7947,6350,6440,5796,7123,5431,7293,6465]
[null,"Product 5",6117,8831,7491,5165,6141,5482,6784,8487,8505,5261,5176,7909]

{"sheet":"Australia ","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in Australia"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",8210,10542,10234,5823,10623,7298,8717,7605,7724,4725,5185,4978]
[null,"Product 2",6240,7778,10003,4351,6165,7158,7951,5117,7013,8197,4753,9617]
[null,"Product 3",5616,10575,7074,5064,9204,10701,4671,6310,6158,4637,8919,5488]
[null,"Product 4",7570,7566,8226,7490,4169,9902,10329,6219,8084,10217,9031,4574]
[null,"Product 5",5885,9527,5888,6905,8877,10794,9817,6184,9510,6020,6746,4304]

{"sheet":"Finland","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,13]]}
[]
[null,"Sales in Finland"]
[]
[null,"Product ","Jan ","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Product 1",3956,3098,3881,3320,3256,4787,2609,2577,4919,2724,2623,3552]
[null,"Product 2",4293,3305,4021,3467,4239,3192,3489,4891,3319,3629,3957,4802]
[null,"Product 3",3779,4048,3905,4555,4021,3439,2805,3220,3827,4563,4614,4661]
[null,"Product 4",3945,4947,2692,4526,4160,4538,3446,3164,3186,4900,4392,3280]
[null,"Product 5",3878,4262,3163,4977,3466,3103,3510,3216,3143,4275,3295,3725]

{"sheet":"Using Hyperlink Function","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using HYPERLINK Function"]
[]
[null,"Name ","Hyperlink"]
[null,"United States",{"$f":"HYPERLINK(\"#'United States'!A1\",\"USA\")","v":"USA"}]
[null,"France ",{"$f":"HYPERLINK(\"#'France '!A1\",\"France\")","v":"France"}]
[null,"Canada",{"$f":"HYPERLINK(\"#'Canada'!A1\",\"Canada\")","v":"Canada"}]
[null,"Mexico ",{"$f":"HYPERLINK(\"#'Mexico '!A1\",\"Mexico\")","v":"Mexico"}]
[null,"Australia ",{"$f":"HYPERLINK(\"#'Australia '!A1\",\"Australia\")","v":"Australia"}]
[null,"Finland",{"$f":"HYPERLINK(\"#'Finland'!A1\",\"Finland\")","v":"Finland"}]

{"sheet":"Using Context Menu","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Utilizing Context Menu"]
[]
[null,"Name"]
[null,"United States "]
[null,"France "]
[null,"Canada"]
[null,"Mexico"]
[null,"Australia "]
[null,"Finland"]

{"sheet":"Combined Formula","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Combined Formula"]
[]
[null,"Name ","Hyperlink"]
[null,"United States",{"$f":"IF(ROW(A1)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A1)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A1)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"United States"}]
[null,"France ",{"$f":"IF(ROW(A2)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A2)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A2)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"France "}]
[null,"Canada",{"$f":"IF(ROW(A3)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A3)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A3)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"Canada"}]
[null,"Mexico ",{"$f":"IF(ROW(A4)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A4)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A4)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"Mexico "}]
[null,"Australia ",{"$f":"IF(ROW(A5)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A5)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A5)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"Australia "}]
[null,"Finland",{"$f":"IF(ROW(A6)>_xlfn.SHEETS(),REPT(NOW(),),SUBSTITUTE(HYPERLINK(\"#'\"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A6)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))&\"'!A1\",TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(INDEX(TabNames,ROW(A6)),\" \",CHAR(255)),\"]\",REPT(\" \",32)),32))),CHAR(255),\" \"))","v":"Finland"}]

{"sheet":"Using Power Query","index":9,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Hyperlink"]
["United States",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"USA\")","v":"USA"}]
["France ",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"France\")","v":"France"}]
["Canada",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"Canada\")","v":"Canada"}]
["Mexico ",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"Mexico\")","v":"Mexico"}]
["Australia ",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"Australia\")","v":"Australia"}]
["Finland",{"$f":"HYPERLINK(\"#'\"&Table_of_Contents_in_Excel_with_Hyperlinks_xlsm[[#This Row],[Name]]&\"'!A1\",\"Finland\")","v":"Finland"}]

{"sheet":"Table of Contents","index":10,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Table of Contents"]
[]
[null,"United States"]
[null,"France "]
[null,"Canada"]
[null,"Mexico "]
[null,"Australia "]
[null,"Finland"]