{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Wallstreetmojo.com","VBA Join Example 1","VBA Join Example 2"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Wallstreetmojo.com","index":0,"n_rows":6,"n_cols":1,"rows_kept":6}
["VBA Join Function Excel Template"]
[]
["Prepared by Dheeraj Vaidya, CFA, FRM"]
["dheeraj@wallstreetmojo.com"]
[]
["visit - www.wallstreetmojo.com"]

{"sheet":"VBA Join Example 1","index":1,"n_rows":2,"n_cols":4,"rows_kept":2}
["First Name","Middle Name","Last Name","Full Name"]
["Ramesh","Kumar","Mishra","Ramesh Kumar Mishra"]

{"sheet":"VBA Join Example 2","index":2,"n_rows":350,"n_cols":3,"rows_kept":350}
["Employee Name","Item sold","Sales"]
["Suresh","Pen Drive",70582]
["Hardeep","Wired Keyboard",29331]
["Aman","Wireless Mouse",39973]
["Suresh","Pen Drive",11190]
["Bablu","Wired Mouse",26036]
["Karun","Wired Keyboard",21995]
["Bablu","Wired Mouse",12161]
["Bablu","Pen Drive",23587]
["Naresh","Wireless Keyboard",72543]
["Sunny","Wired Mouse",67249]
["Naresh","Wireless Keyboard",56063]
["Madhur","Wired Keyboard",26375]
["Hardeep","Wireless Mouse",54450]
["Karun","Wired Keyboard",79074]
["Madhur","Hard Disk",17676]
["Bablu","Wired Keyboard",94318]
["Chetan","Wireless Mouse",59518]
["Madhur","Pen Drive",89203]
["Hardeep","Wired Keyboard",51668]
["Naresh","Wireless Mouse",76464]
["Manish","Laptop",61632]
["Naresh","Wired Mouse",91636]
["Parvinder","Wireless Mouse",32699]
["Sunny","Wired Mouse",17143]
["Bablu","Wireless Keyboard",64917]
["Lashay","Hard Disk",64654]
["Lashay","Wired Keyboard",52536]
["Bablu","Pen Drive",44753]
["Naresh","Laptop",79811]
["Lashay","Wireless Keyboard",52486]
["Manish","Wireless Keyboard",46296]
["Madhur","Pen Drive",17679]
["Bablu","Pen Drive",86412]
["Lashay","Wired Keyboard",52334]
["Lashay","Pen Drive",60496]
["Parvinder","Wireless Mouse",67477]
["Madhur","Laptop",48354]
["Aman","Laptop",37177]
["Madhur","Hard Disk",88452]
["Parvinder","Wireless Keyboard",19353]
["Hardeep","Wired Mouse",62095]
["Naresh","Wired Keyboard",82128]
["Bablu","Hard Disk",64998]
["Aman","Wireless Keyboard",22565]
["Aman","Wired Mouse",50244]
["Bablu","Laptop",85409]
["Lashay","Wired Keyboard",64826]
["Karun","Wireless Keyboard",27690]
["Karun","Laptop",94099]
["Lashay","Wireless Keyboard",68260]
["Suresh","Wired Keyboard",46402]
["Hardeep","Pen Drive",66954]
["Manish","Laptop",47981]
["Sunny","Hard Disk",52129]
["Suresh","Pen Drive",33646]
["Suresh","Laptop",37253]
["Karun","Wireless Keyboard",49021]
["Bablu","Hard Disk",68202]
["Lashay","Laptop",13424]
["Manish","Wireless Keyboard",66987]
["Parvinder","Laptop",83677]
["Sunny","Wireless Keyboard",70935]
["Karun","Pen Drive",15410]
["Naresh","Laptop",38501]
["Karun","Wireless Keyboard",86286]
["Madhur","Hard Disk",50381]
["Parvinder","Wired Keyboard",69344]
["Naresh","Wireless Mouse",66073]
["Manish","Wired Mouse",57493]
["Parvinder","Hard Disk",89072]
["Madhur","Wireless Mouse",49410]
["Chetan","Laptop",72282]
["Hardeep","Wired Keyboard",77041]
["Karun","Wireless Mouse",59313]
["Sunny","Hard Disk",26333]
["Naresh","Wired Mouse",65274]
["Parvinder","Wired Keyboard",22100]
["Ashok","Laptop",46977]
["Karun","Wireless Mouse",89501]
["Karun","Wired Keyboard",28647]
["Parvinder","Wired Keyboard",83374]
["Ashok","Hard Disk",77575]
["Naresh","Laptop",81454]
["Karun","Wireless Mouse",14950]
["Manish","Hard Disk",66522]
["Manish","Wired Keyboard",78731]
["Manish","Laptop",14790]
["Bablu","Wired Mouse",62111]
["Madhur","Hard Disk",22341]
["Karun","Wireless Keyboard",10777]
["Madhur","Hard Disk",80888]
["Parvinder","Pen Drive",32346]
["Hardeep","Laptop",79922]
["Aman","Wireless Mouse",76062]
["Suresh","Hard Disk",53036]
["Madhur","Laptop",69214]
["Bablu","Wireless Keyboard",49454]
["Madhur","Wireless Mouse",67496]
["Aman","Wireless Keyboard",20545]
["Suresh","Hard Disk",80522]
["Manish","Laptop",23860]
["Parvinder","Wired Keyboard",82903]
["Sunny","Wireless Keyboard",55008]
["Aman","Pen Drive",22428]
["Lashay","Wired Mouse",32082]
["Chetan","Laptop",83868]
["Aman","Wireless Mouse",54430]
["Chetan","Wireless Keyboard",39337]
["Parvinder","Wired Mouse",52139]
["Lashay","Hard Disk",14926]
["Aman","Pen Drive",57212]
["Lashay","Wired Keyboard",11499]
["Naresh","Laptop",57175]
["Aman","Hard Disk",73861]
["Madhur","Wireless Keyboard",82955]
["Lashay","Wired Mouse",29319]
["Madhur","Wired Mouse",26434]
["Naresh","Wireless Keyboard",25752]
["Karun","Wireless Keyboard",92993]
["Ashok","Hard Disk",63865]
["Sunny","Pen Drive",50743]
["Madhur","Wired Keyboard",32001]
["Bablu","Hard Disk",12089]
["Naresh","Wireless Mouse",21931]
["Madhur","Hard Disk",89465]
["Karun","Pen Drive",82017]
["Ashok","Wired Keyboard",42198]
["Parvinder","Hard Disk",50027]
["Chetan","Wired Mouse",59027]
["Bablu","Wireless Keyboard",90269]
["Suresh","Wireless Mouse",57357]
["Bablu","Wireless Keyboard",20150]
["Suresh","Wireless Keyboard",63263]
["Naresh","Wireless Keyboard",45722]
["Aman","Wireless Mouse",83019]
["Naresh","Wireless Mouse",26566]
["Suresh","Wired Keyboard",87402]
["Bablu","Wired Mouse",89056]
["Lashay","Wired Mouse",65704]
["Naresh","Wireless Mouse",31206]
["Sunny","Hard Disk",87682]
["Chetan","Pen Drive",64176]
["Ashok","Wireless Keyboard",66056]
["Parvinder","Laptop",79158]
["Aman","Wireless Mouse",60896]
["Hardeep","Wired Mouse",40532]
["Ashok","Pen Drive",12165]
["Ashok","Pen Drive",81999]
["Madhur","Wireless Mouse",60657]
["Naresh","Hard Disk",86314]
["Naresh","Laptop",14060]
["Karun","Wireless Mouse",19517]
["Karun","Laptop",23400]
["Hardeep","Wired Mouse",27934]
["Parvinder","Wired Mouse",33892]
["Ashok","Pen Drive",64672]
["Manish","Laptop",66172]
["Chetan","Wireless Mouse",60120]
["Hardeep","Wireless Mouse",76290]
["Naresh","Pen Drive",60407]
["Parvinder","Wired Keyboard",24425]
["Bablu","Wired Mouse",17689]
["Suresh","Hard Disk",54705]
["Parvinder","Pen Drive",91957]
["Hardeep","Hard Disk",39958]
["Sunny","Wired Keyboard",17895]
["Hardeep","Hard Disk",51904]
["Naresh","Laptop",32376]
["Aman","Wired Keyboard",73576]
["Hardeep","Wired Keyboard",33172]
["Suresh","Laptop",58743]
["Naresh","Wired Mouse",41516]
["Karun","Pen Drive",15367]
["Chetan","Wireless Mouse",82414]
["Sunny","Hard Disk",13551]
["Ashok","Wireless Mouse",70529]
["Parvinder","Wired Keyboard",82548]
["Ashok","Wireless Keyboard",76570]
["Lashay","Pen Drive",54540]
["Bablu","Hard Disk",84346]
["Manish","Hard Disk",36259]
["Sunny","Wired Keyboard",28228]
["Naresh","Laptop",44623]
["Madhur","Hard Disk",49999]
["Naresh","Laptop",54630]
["Suresh","Wireless Keyboard",63971]
["Aman","Wireless Mouse",80920]
["Parvinder","Laptop",90963]
["Naresh","Wired Keyboard",49888]
["Hardeep","Wired Mouse",54185]
["Sunny","Laptop",40023]
["Karun","Pen Drive",16698]
["Aman","Pen Drive",24369]
["Karun","Wired Keyboard",40543]
["Suresh","Wired Keyboard",44468]
["Parvinder","Wireless Mouse",30857]
["Aman","Laptop",50463]
["Chetan","Wireless Keyboard",53021]
["Hardeep","Wired Mouse",50661]
["Hardeep","Wired Keyboard",13974]
["Ashok","Pen Drive",15748]
["Naresh","Wireless Keyboard",78031]
["Manish","Wired Keyboard",93665]
["Suresh","Wireless Keyboard",67469]
["Madhur","Hard Disk",17406]
["Bablu","Hard Disk",23713]
["Aman","Wireless Keyboard",63462]
["Hardeep","Wireless Mouse",56198]
["Bablu","Wireless Mouse",75218]
["Suresh","Hard Disk",39303]
["Suresh","Wired Mouse",50583]
["Ashok","Wired Keyboard",75500]
["Naresh","Pen Drive",50605]
["Sunny","Wireless Mouse",33481]
["Suresh","Pen Drive",60661]
["Madhur","Wired Mouse",14743]
["Aman","Pen Drive",83154]
["Aman","Pen Drive",42123]
["Lashay","Wireless Mouse",77448]
["Manish","Hard Disk",94872]
["Aman","Hard Disk",78631]
["Manish","Wireless Mouse",70232]
["Madhur","Wireless Mouse",84321]
["Madhur","Laptop",75001]
["Aman","Hard Disk",60510]
["Ashok","Wired Mouse",26581]
["Chetan","Laptop",84428]
["Madhur","Pen Drive",23579]
["Hardeep","Wired Keyboard",82753]
["Naresh","Wired Keyboard",55214]
["Lashay","Wireless Mouse",19163]
["Aman","Wireless Keyboard",50308]
["Suresh","Wireless Mouse",80908]
["Madhur","Wired Keyboard",19437]
["Lashay","Hard Disk",74105]
["Ashok","Wireless Mouse",55732]
["Naresh","Wired Mouse",37194]
["Lashay","Wireless Mouse",62323]
["Hardeep","Wired Mouse",53446]
["Ashok","Wired Keyboard",64257]
["Karun","Wired Mouse",84496]
["Sunny","Wireless Mouse",23894]
["Chetan","Laptop",38591]
["Karun","Laptop",25224]
["Hardeep","Wired Mouse",55993]
["Manish","Wireless Keyboard",68335]
["Hardeep","Hard Disk",47016]
["Manish","Wireless Keyboard",25833]
["Karun","Wired Keyboard",76969]
["Ashok","Laptop",68156]
["Hardeep","Pen Drive",14542]
["Karun","Wired Keyboard",41466]
["Madhur","Wired Keyboard",57941]
["Naresh","Wireless Mouse",36871]
["Parvinder","Wired Keyboard",69926]
["Chetan","Wired Mouse",90822]
["Naresh","Pen Drive",91849]
["Parvinder","Pen Drive",59228]
["Sunny","Pen Drive",38582]
["Bablu","Wireless Mouse",23138]
["Madhur","Wireless Keyboard",37377]
["Bablu","Wireless Keyboard",61352]
["Suresh","Wired Mouse",86257]
["Aman","Wireless Keyboard",70763]
["Bablu","Hard Disk",58924]
["Sunny","Wired Mouse",13589]
["Bablu","Wired Keyboard",83564]
["Karun","Wired Mouse",41105]
["Hardeep","Wireless Mouse",58302]
["Sunny","Wireless Keyboard",54034]
["Lashay","Hard Disk",77328]
["Ashok","Pen Drive",64025]
["Parvinder","Laptop",47584]
["Bablu","Pen Drive",17338]
["Naresh","Hard Disk",65967]
["Naresh","Pen Drive",62326]
["Naresh","Pen Drive",41858]
["Aman","Pen Drive",53810]
["Ashok","Pen Drive",44490]
["Lashay","Wired Keyboard",29705]
["Bablu","Laptop",40210]
["Manish","Wireless Mouse",76328]
["Manish","Wired Mouse",63697]
["Aman","Wireless Keyboard",71125]
["Aman","Hard Disk",83788]
["Suresh","Wireless Keyboard",20916]
["Ashok","Pen Drive",33032]
["Ashok","Wireless Mouse",82736]
["Manish","Wired Mouse",15868]
["Lashay","Wired Mouse",44518]
["Aman","Hard Disk",67487]
["Lashay","Laptop",36236]
["Naresh","Laptop",42004]
["Chetan","Pen Drive",50666]
["Hardeep","Wireless Keyboard",18826]
["Hardeep","Wireless Keyboard",60218]
["Ashok","Wired Keyboard",84243]
["Sunny","Wired Keyboard",30868]
["Parvinder","Wired Mouse",71444]
["Naresh","Wired Keyboard",66134]
["Madhur","Wireless Keyboard",36111]
["Bablu","Pen Drive",38874]
["Manish","Wireless Mouse",93410]
["Ashok","Wireless Keyboard",60904]
["Chetan","Wireless Keyboard",42755]
["Hardeep","Laptop",28239]
["Aman","Wireless Keyboard",32077]
["Manish","Laptop",42264]
["Naresh","Wired Keyboard",58249]
["Chetan","Wireless Keyboard",26054]
["Suresh","Wired Mouse",62675]
["Ashok","Wired Mouse",93682]
["Suresh","Wired Keyboard",20229]
["Ashok","Wired Mouse",12040]
["Karun","Pen Drive",55214]
["Chetan","Wireless Keyboard",60709]
["Madhur","Laptop",16609]
["Manish","Wireless Keyboard",59798]
["Chetan","Hard Disk",86717]
["Manish","Wireless Keyboard",13569]
["Karun","Wired Keyboard",92042]
["Madhur","Pen Drive",61582]
["Aman","Hard Disk",27424]
["Aman","Wired Mouse",64726]
["Madhur","Wireless Keyboard",78003]
["Ashok","Wired Mouse",41407]
["Suresh","Wired Keyboard",50626]
["Aman","Laptop",53563]
["Sunny","Hard Disk",82415]
["Manish","Laptop",88252]
["Suresh","Wired Mouse",34957]
["Bablu","Wired Keyboard",83657]
["Naresh","Pen Drive",29644]
["Madhur","Wireless Keyboard",13183]
["Parvinder","Pen Drive",90862]
["Suresh","Hard Disk",77993]
["Sunny","Wired Keyboard",55463]
["Aman","Laptop",63617]
["Ashok","Laptop",10391]
["Suresh","Pen Drive",36166]
["Manish","Wired Keyboard",92473]
["Karun","Wireless Keyboard",66154]
["Karun","Wired Keyboard",80185]
["Karun","Wireless Keyboard",12469]
["Ashok","Hard Disk",48680]
["Karun","Wireless Mouse",38459]
["Sunny","Wired Mouse",67347]
["Suresh","Wireless Mouse",43472]
["Suresh","Laptop",20255]