{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":[".AddItem Command","Row_Source Property","ComboBox","InputBox","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":".AddItem Command","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Drop Down List Values Using .AddItem Command"]
[]
[null,"Name","ID","Department","Salary"]
[null,"Jhon",1102,"Sales",8000]
[null,"Mira",1205,"Marketing",7500]
[null,"Andrew",1107,"Sales",8500]
[null,"Jimmy",1005,"Finance",5000]
[null,"Alisa",1215,"Marketing",7000]
[null,"Martha",1109,"Sales",8000]
[null,"Harry",1004,"Finance",6500]
[null,"Stuart",1006,"Finance",6000]
[null,"Maddison",1112,"Sales",7000]
[null,"Marcus",1207,"Marketing",8000]
[null,"Lio",1106,"Sales",10000]

{"sheet":"Row_Source Property","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting Drop Down List Values Using RowSource Property"]
[]
[null,"Name","ID","Department","Salary"]
[null,"Jhon",1102,"Sales",8000]
[null,"Mira",1205,"Marketing",7500]
[null,"Andrew",1107,"Sales",8500]
[null,"Jimmy",1005,"Finance",5000]
[null,"Alisa",1215,"Marketing",7000]
[null,"Martha",1109,"Sales",8000]
[null,"Harry",1004,"Finance",6500]
[null,"Stuart",1006,"Finance",6000]
[null,"Maddison",1112,"Sales",7000]
[null,"Marcus",1207,"Marketing",8000]
[null,"Lio",1106,"Sales",10000]

{"sheet":"ComboBox","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Utilizing ComboBox to Add Drop Down List"]
[]
[null,"Name","ID","Department","Salary"]
[null,"Jhon",1102,"Sales",8000]
[null,"Mira",1205,"Marketing",7500]
[null,"Andrew",1107,"Sales",8500]
[null,"Jimmy",1005,"Finance",5000]
[null,"Alisa",1215,"Marketing",7000]
[null,"Martha",1109,"Sales",8000]
[null,"Harry",1004,"Finance",6500]
[null,"Stuart",1006,"Finance",6000]
[null,"Maddison",1112,"Sales",7000]
[null,"Marcus",1207,"Marketing",8000]
[null,"Lio",1106,"Sales",10000]

{"sheet":"InputBox","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA InputBox"]
[]
[null,"Name","ID","Department","Salary"]
[null,"Jhon",1102,"Sales",8000]
[null,"Mira",1205,"Marketing",7500]
[null,"Andrew",1107,"Sales",8500]
[null,"Jimmy",1005,"Finance",5000]
[null,"Alisa",1215,"Marketing",7000]
[null,"Martha",1109,"Sales",8000]
[null,"Harry",1004,"Finance",6500]
[null,"Stuart",1006,"Finance",6000]
[null,"Maddison",1112,"Sales",7000]
[null,"Marcus",1207,"Marketing",8000]
[null,"Lio",1106,"Sales",10000]

{"sheet":"Data Validation","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating Data Validation Drop Down List with VBA"]
[]
[null,"Name","ID","Department","Salary",null,"Name"]
[null,"Jhon",1102,"Sales",8000,null,"Maddison"]
[null,"Mira",1205,"Marketing",7500]
[null,"Andrew",1107,"Sales",8500,null,"ID"]
[null,"Jimmy",1005,"Finance",5000,null,{"$f":"VLOOKUP(G5,$B$5:$E$15,2,0)","v":1112}]
[null,"Alisa",1215,"Marketing",7000,null,"Department"]
[null,"Martha",1109,"Sales",8000,null,{"$f":"VLOOKUP($G$5,$B$5:$E$15,3,0)","v":"Sales"}]
[null,"Harry",1004,"Finance",6500,null,"Salary"]
[null,"Stuart",1006,"Finance",6000,null,{"$f":"VLOOKUP(G5,$B$5:$E$15,4,0)","v":7000}]
[null,"Maddison",1112,"Sales",7000]
[null,"Marcus",1207,"Marketing",8000]
[null,"Lio",1106,"Sales",10000]