{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["TOC_VBA","Introduction","Outline","Cells_NamedRanges","FollowHyperlinks","AddressFunction","TOC_formula","TOC_PQ","LinksToFolders","LinksToFolders_Dyn","SendEmails","RolloverTechnique","SneakPeak"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":12,"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":"TOC_VBA","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Table of Contents"]
[]
[null,1,"Introduction"]
[null,2,"Outline"]
[null,3,"Cells_NamedRanges"]
[null,4,"FollowHyperlinks"]
[null,5,"AddressFunction"]
[null,6,"TOC_formula"]
[null,7,"TOC_PQ"]
[null,8,"FilesFunction"]
[null,9,"LinksToFolders"]
[null,10,"LinksToFolders_Dyn"]
[null,11,"SendEmails"]
[null,12,"RolloverTechnique"]
[null,13,"SneakPeak"]
[null,14,"Images"]
[null,15,"Raw Data"]

{"sheet":"Introduction","index":1,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,6,6,12]]}
[]
[]
[null,null,null,null,null,null,"Getting Hyper with Hyperlinks",null,null,null,null,null,null,null,"Victor Momoh Profile"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ExcelMoments"]

{"sheet":"Outline","index":2,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Outline"]
["Hyperlinks to cells,named ranges, tables"]
["Follow Hyperlinks, clear"]
["Hyperlink and Address function"]
["Hyperlink to minimum, maximum, first, last cells"]
["Table of Contents - formulas"]
["Table of Content using PQ & Hyperlink"]
["Hyperlinks - command prompts"]
["Hyperlink folders"]
["Hyperlink folders and subfolders"]
["Hyperlinks for sending emails"]
["Rollover technique"]
["Camera tool and hyperlinks"]

{"sheet":"Cells_NamedRanges","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Task","Link","Reference",null,null,"Name","Location","Excel Tricks Count"]
[null,"Hyperlink to cell J3",{"$f":"HYPERLINK(\"#G3\",\"Alan\")","v":"Alan"},null,null,null,"Alan","London",71]
[null,null,null,null,null,null,"Michael","Nigeria",15]
[null,"Hyperlink with ranged name in cell",{"$f":"HYPERLINK(\"#Total_Tricks\",\"named range\")","v":"named range"},"Total_Tricks",null,null,"Bob","United States",1000]
[null,null,null,null,null,null,"Oakley","Canaada",50]
[null,"Hyperlink to a Table",{"$f":"HYPERLINK(\"#\"&D7,\"Mvps\")","v":"Mvps"},"MVP_Table",null,null,"Claire","United Kingdom",70]
[null,null,null,null,null,null,"Obeng","Ghana",34]
[null,"Hyperlink to table Header",null,"MVP_Table[[#Headers],[Name]]",null,null,"Victor","Nigeria",2]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I3:I9)","v":1242}]
[null,"Hyperlink to Another Sheet \n(within same workbook)",{"$f":"HYPERLINK(\"#Outline!A1\",\"LinkOutline\")","v":"LinkOutline"},"Outline"]
[null,null,null,null,null,null,"Name","Location","Excel Tricks Count"]
[null,"Hyperlink to a webpage",{"$f":"HYPERLINK(\"https://www.google.com\",\"Google site\")","v":"Google site"},"Google site",null,null,"Alan","London",71]
[null,null,null,null,null,null,"Michael","Nigeria",15]
[null,"long link",{"$f":"HYPERLINK(\"[LondonExcelMeetup_Hyper_hyperlinks.xlsm]Outline!A1\",\"mylink\")","v":"mylink"},null,null,null,"Bob","United States",1000]
[null,null,null,null,null,null,"Oakley","Canaada",50]
[null,null,null,null,null,null,"Claire","United Kingdom",70]
[null,null,null,null,null,null,"Obeng","Ghana",34]
[null,null,null,null,null,null,"Victor","Nigeria",2]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I13:I19)","v":1242}]

{"sheet":"FollowHyperlinks","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Link to my linkedin page","My linkedin profile"]

{"sheet":"AddressFunction","index":5,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Hyperlink formulas"]
[]
[null,"Highest Sales",{"$f":"HYPERLINK(\"#\"&CELL(\"address\",_xlfn.XLOOKUP(MAX(ActorPurchase[Amount]),ActorPurchase[Amount],ActorPurchase[Amount])),\"Maximum\")","v":"Maximum"},"Maximum"]
[]
[null,"Lowest Sales",{"$f":"HYPERLINK(\"#\"&CELL(\"address\",_xlfn.XLOOKUP(MIN(ActorPurchase[Amount]),ActorPurchase[Amount],ActorPurchase[Amount])),\"Minimum\")","v":"Minimum"},"Minimum"]
[null,null,null,null,null,null,null,"Date","Sales Person","Item","Amount"]
[null,"First Cell",{"$f":"HYPERLINK(\"#\"&CELL(\"address\",ActorPurchase[[#Headers],[Date]]),\"First Cell\")","v":"First Cell"},"First Cell",null,null,null,"2018-01-01","Arnold Scharzenegger","Biros",80]
[null,null,null,null,null,null,null,"2018-01-04","Chuck Norris","Shoes",150]
[null,"Last Cell",null,"Last Cell",null,null,null,"2018-01-04","Bruce Willis","pencils",140]
[null,null,null,null,null,null,null,"2018-01-10","Steven Seagal","Wrsist Watches",150]
[null,"Next Empty cell",{"$f":"HYPERLINK(\"#H\" & ROW(ActorPurchase[#Headers])+COUNTA(ActorPurchase[Date])+1,\"Empty cell\")","v":"Empty cell"},"Next Empty",null,null,null,"2018-01-12","Bruce Willis","Biros",300]
[null,null,null,null,null,null,null,"2018-01-12","Arnold Scharzenegger","Biros",30]
[null,null,null,null,null,null,null,"2018-01-13","Arnold Scharzenegger","Shoes",80]
[null,null,null,null,null,null,null,"2018-01-14","Chuck Norris","Biros",70]
[null,null,null,null,null,null,null,"2018-01-15","Arnold Scharzenegger","Shoes",80]
[null,"Xlookup returning reference",{"$f":"SUM(K8:_xlfn.XLOOKUP(30,ActorPurchase[Amount],ActorPurchase[Amount]))","v":850},null,null,null,null,"2018-01-15","Arnold Scharzenegger","Shoes",20]
[null,null,null,null,null,null,null,"2018-01-16","Steven Seagal","Shoes",120]
[null,null,null,null,null,null,null,"2018-01-16","Arnold Scharzenegger","Top Coat",100]
[null,null,null,null,null,null,null,"2018-01-17","Steven Seagal","Wrsist Watches",160]
[null,null,null,null,null,null,null,"2018-01-17","Bruce Willis","Top Coat",90]
[null,null,null,null,null,null,null,"2018-01-17","Bruce Willis","Shoes",130]
[null,null,null,null,null,null,null,"2018-01-18","Arnold Scharzenegger","Wrsist Watches",30]
[null,null,null,null,null,null,null,"2018-01-19","Steven Seagal","Wrsist Watches",20]
[null,null,null,null,null,null,null,"2018-01-20","Steven Seagal","Top Coat",90]
[null,null,null,null,null,null,null,"2018-01-22","Chuck Norris","Wrsist Watches",30]
[null,null,null,null,null,null,null,"2018-01-22","Bruce Willis","Biros",120]
[null,null,null,null,null,null,null,"2018-01-23","Chuck Norris","pencils",70]
[null,null,null,null,null,null,null,"2018-01-23","Steven Seagal","Biros",20]

{"sheet":"TOC_formula","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Sheets in Workbook","Link (text not updated)","Modified Link (text fixed)"]
[null,{"$f":"TRANSPOSE(SheetList)","v":"TOC_VBA"},{"$f":"HYPERLINK(\"#\"&_xlfn.ANCHORARRAY(B2)&\"!A1\",_xlfn.ANCHORARRAY(B2))","v":"TOC_VBA"},{"$f":"SUBSTITUTE(HYPERLINK(\"#\"&_xlfn.ANCHORARRAY(B2)&\"!A1\",_xlfn.ANCHORARRAY(B2)),$B$2,_xlfn.ANCHORARRAY(B2))","v":"TOC_VBA"}]
[null,"Introduction","TOC_VBA","Introduction",{"$f":"NOW()","v":"2021-11-11T12:19:16.600"}]
[null,"Outline","TOC_VBA","Outline",{"$f":"T(E3)","v":""}]
[null,"Cells_NamedRanges","TOC_VBA","Cells_NamedRanges"]
[null,"FollowHyperlinks","TOC_VBA","FollowHyperlinks"]
[null,"AddressFunction","TOC_VBA","AddressFunction"]
[null,"TOC_formula","TOC_VBA","TOC_formula"]
[null,"TOC_PQ","TOC_VBA","TOC_PQ"]
[null,"LinksToFolders","TOC_VBA","LinksToFolders"]
[null,"LinksToFolders_Dyn","TOC_VBA","LinksToFolders_Dyn"]
[null,"SendEmails","TOC_VBA","SendEmails"]
[null,"RolloverTechnique","TOC_VBA","RolloverTechnique"]
[null,"SneakPeak","TOC_VBA","SneakPeak"]

{"sheet":"TOC_PQ","index":7,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ThisWkbPath"]
[null,null,null,{"$f":"_xlfn.LET(_xlpm.x,CELL(\"filename\"),SUBSTITUTE(LEFT(_xlpm.x,SEARCH(\"]\",_xlpm.x)-1),\"[\",\"\"))","v":"C:\\Users\\vicmo\\Desktop\\LondonExcelMeetup_Hyper_hyperlinks.xlsm"}]
["Sheetnames","Link"]
["TOC_VBA",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"TOC_VBA"},null,{"$f":"CELL(\"filename\")","v":"C:\\Users\\vicmo\\Desktop\\[LondonExcelMeetup_Hyper_hyperlinks.xlsm]Introduction"}]
["Sheet1",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"Sheet1"}]
["Introduction",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"Introduction"}]
["Outline",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"Outline"}]
["Cells_NamedRanges",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"Cells_NamedRanges"}]
["FollowHyperlinks",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"FollowHyperlinks"}]
["AddressFunction",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"AddressFunction"}]
["TOC_formula",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"TOC_formula"}]
["TOC_PQ",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"TOC_PQ"}]
["FilesFunction",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"FilesFunction"}]
["LinksToFolders",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"LinksToFolders"}]
["LinksToFolders_Dyn",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"LinksToFolders_Dyn"}]
["SendEmails",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"SendEmails"},null,null,null,null,null,null,null,null,null,"="]
["RolloverTechnique",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"RolloverTechnique"}]
["SneakPeak",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"SneakPeak"}]
["ImagesLink",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"ImagesLink"}]
["Raw Data",{"$f":"HYPERLINK(\"#'\"&LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]]&\"'!A1\",LondonExcelMeetup_Hyper_hyperlinks_xlsm[[#This Row],[Sheetnames]])","v":"Raw Data"}]

{"sheet":"LinksToFolders","index":8,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Primary Folder","D:\\Celebrities\\"]
[]
["Folder Names","Hyperlinks"]
["Alan Murray",{"$f":"HYPERLINK($B$1&A4,A4)","v":"Alan Murray"}]
["Aliko Dangote",{"$f":"HYPERLINK($B$1&A5,A5)","v":"Aliko Dangote"}]
["allyson Felix","allyson Felix"]
["Bernard Arnault","Bernard Arnault"]
["Bill Gates","Bill Gates"]
["Connor Mcgregor","Connor Mcgregor"]
["Cristiano Ronaldo","Cristiano Ronaldo"]
["Elon Musk","Elon Musk"]
["harry Kane","harry Kane"]
["J.K. Rowling","J.K. Rowling"]
["Jamie Vardy","Jamie Vardy"]
["Jeff Bezos","Jeff Bezos"]
["kamaru Usman","kamaru Usman"]
["Larry Ellison","Larry Ellison"]
["Larry Page","Larry Page"]
["Lebron James","Lebron James"]
["Lennox lewis","Lennox lewis"]
["lionel messi","lionel messi"]
["Marcus Rashford","Marcus Rashford"]
["Mark Zuckerberg","Mark Zuckerberg"]
["Mohammed Salah","Mohammed Salah"]
["Mukesh Ambani","Mukesh Ambani"]
["Oprah Winfrey","Oprah Winfrey"]
["Romelu Lukaku","Romelu Lukaku"]
["Rowan Atkinson","Rowan Atkinson"]
["Sergey Brin","Sergey Brin"]
["Tiger Woods","Tiger Woods"]
["tyson Fury","tyson Fury"]
["Usain Bolt","Usain Bolt"]
["Warren Buffett","Warren Buffett"]

{"sheet":"LinksToFolders_Dyn","index":9,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,"FolderPath"]
[null,"Primary Folder","D:\\Celebrities\\"]
[]
[null,"Folder Names","Hyperlinks"]
[null,"Name","Column1"]
[null,"Alan Murray",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Alan Murray"}]
[null,"Aliko Dangote",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Aliko Dangote"}]
[null,"allyson Felix",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\allyson Felix"}]
[null,"Bernard Arnault",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Bernard Arnault"}]
[null,"Bill Gates",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Bill Gates"}]
[null,"Connor Mcgregor",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Connor Mcgregor"}]
[null,"Cristiano Ronaldo",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Cristiano Ronaldo"}]
[null,"Elon Musk",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Elon Musk"}]
[null,"harry Kane",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\harry Kane"}]
[null,"J.K. Rowling",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\J.K. Rowling"}]
[null,"Jamie Vardy",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Jamie Vardy"}]
[null,"Jeff Bezos",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Jeff Bezos"}]
[null,"kamaru Usman",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\kamaru Usman"}]
[null,"Larry Ellison",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Larry Ellison"}]
[null,"Larry Page",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Larry Page"}]
[null,"Lebron James",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Lebron James"}]
[null,"Lennox lewis",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Lennox lewis"}]
[null,"lionel messi",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\lionel messi"}]
[null,"Marcus Rashford",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Marcus Rashford"}]
[null,"Mark Zuckerberg",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Mark Zuckerberg"}]
[null,"Mohammed Salah",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Mohammed Salah"}]
[null,"Mukesh Ambani",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Mukesh Ambani"}]
[null,"Oprah Winfrey",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Oprah Winfrey"}]
[null,"Romelu Lukaku",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Romelu Lukaku"}]
[null,"Rowan Atkinson",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Rowan Atkinson"}]
[null,"Sergey Brin",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Sergey Brin"}]
[null,"Tiger Woods",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Tiger Woods"}]
[null,"tyson Fury",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\tyson Fury"}]
[null,"Usain Bolt",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Usain Bolt"}]
[null,"Warren Buffett",{"$f":"HYPERLINK(FolderPathTable[FolderPath]&Camtasia_Studio[[#This Row],[Name]])","v":"D:\\Celebrities\\Warren Buffett"}]

{"sheet":"SendEmails","index":10,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Name","Victor"]
["Mailto:","vicmomentum@gmail.com"]
["cc","ikpemomoh@yahoo.com"]
["bcc","ikpemomoh@yahoo.com"]
["subject","Invitation to webinar"]
["body",{"$f":"\"Hello \" & B1&\",\"&\"%0D%0A%0D%0A\" & \"You are cordially invited\"&\"%0D%0A%0D%0A\"&\"Regards\"&\"%0DAdmin\"","v":"Hello Victor,%0D%0A%0D%0AYou are cordially invited%0D%0A%0D%0ARegards%0DAdmin"}]
["Email",{"$f":"HYPERLINK(A2&B2&\"?\"&A5&\"=\"&B5&\"&\"&A3&\"=\"&B3&\"&\"&A6&\"=\"&B6,\"Send Email\")","v":"Send Email"}]
[]
["Email_v2",{"$f":"HYPERLINK(\n\"mailto:\"&B2&\n\"?Subject=\"&B5&\n\"&cc=\"&B3&\n\"&bcc=\"&B4&\n\"&body=\"&B6,\n\"HyperlinkedEmail\")","v":"HyperlinkedEmail"}]
[]
[]
[]
[null,"Send me an email"]

{"sheet":"RolloverTechnique","index":11,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"London","Rome","Riyadh","Lagos","California"]
["Year",{"$f":"IFERROR(HYPERLINK(RolloverTech(B1),B1),B1)","v":"London"},{"$f":"IFERROR(HYPERLINK(RolloverTech(C1),C1),C1)","v":"Rome"},{"$f":"IFERROR(HYPERLINK(RolloverTech(D1),D1),D1)","v":"Riyadh"},{"$f":"IFERROR(HYPERLINK(RolloverTech(E1),E1),E1)","v":"Lagos"},{"$f":"IFERROR(HYPERLINK(RolloverTech(F1),F1),F1)","v":"California"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR","Lagos"]
[2012,200,400,250,350,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,{"$f":"INDEX($B$3:$F$13,_xlfn.SEQUENCE(COUNTA($X$3:$X$13)),MATCH(Y2,$B$2:$F$2,0))","v":350}]
[2013,450,900,500,600,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,600]
[2014,550,650,300,350,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,350]
[2015,200,800,650,200,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,200]
[2016,200,100,550,550,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,550]
[2017,700,700,450,150,650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,150]
[2018,400,650,950,400,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,400]
[2019,850,300,300,350,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,350]
[2020,200,250,450,750,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,750]
[2021,900,650,150,250,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,250]
[2022,550,650,350,150,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,150]

{"sheet":"SneakPeak","index":12,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Introduction",{"$f":"IFERROR(HYPERLINK(LinkedPicturesUDF(A3),A3),A3)","v":"Introduction"}]
["Outline",{"$f":"IFERROR(HYPERLINK(LinkedPicturesUDF(A4),A4),A4)","v":"Outline"}]
["Cells_NamedRanges",{"$f":"IFERROR(HYPERLINK(LinkedPicturesUDF(A5),A5),A5)","v":"Cells_NamedRanges"}]
["TOC_formula",{"$f":"IFERROR(HYPERLINK(LinkedPicturesUDF(A6),A6),A6)","v":"TOC_formula"}]
[]
[]
[]
[]
[]
["not working"]
[]
[{"$f":"Introduction!A1:F33","v":0}]