{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SVBA_Answer"],"not_rendered":{"charts":0,"images":2,"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":"SVBA_Answer","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,9,17,15],[6,9,8,10],[6,11,8,15],[9,9,11,10],[9,11,9,15],[10,11,10,15],[11,11,11,15]]}
[]
["Fruits","Region",null,"Legumes","Region",null,"Vegetables","Region"]
["Pineapple","North",null,"Pumpkin","South",null,"Chard","East"]
["Barbados Ch",null,null,"Zucchini",null,null,"Cress"]
["Banana","North",null,"Garlic","South",null,"Celery","East"]
["Cashew","North",null,"Eggplant","South",null,"Artichoke"]
["Bean",null,null,"Onion","South",null,"Lettuce",null,null,"Instructions:",null,"Add a button to a worksheet and assign it to a macro the selects the current region. If any data are missing complete them with the value directly above."]
["Raspberry",null,null,"Carrot",null,null,"Alfalfa"]
["Goji","South",null,"Chayote","West",null,"Almeirão","North"]
["Guarana","South",null,"Cauliflower",null,null,"Asparagus",null,null,"Reminder:",null,"ALT + F11 - Open VBE"]
["Jaboticaba",null,null,"Pea","West",null,"Broccoli","North",null,null,null,"Check the code in Solution_Module"]
["Jambo","South",null,"Broad bean",null,null,"Catalonian","North",null,null,null,"On VBE press F5 to execute the code"]
["Orange",null,null,"Ginger","West",null,"Chive"]
["Lemon",null,null,"Jiló",null,null,"Chicory","North"]
["Apple","East",null,"Lentil","North",null,"Coriander","South"]
["Mango",null,null,"Maxixe",null,null,"Cabbage","South"]
["Tangerine",null,null,"Corn","North",null,"Endive"]
["Strawberry","East",null,"Turnip",null,null,"Spinach","South"]
["Noni",null,null,"Cucumber","North",null,"Mint"]
["Physalis","West",null,"Okra","East",null,"Basil","West"]
["Pitanga",null,null,"Radish",null,null,"Mustard"]
["Pomegranate","West",null,"Cabbage","East",null,"Arugula","West"]
["Tamarind",null,null,"Soy","East",null,"Parsley"]
["Ugli",null,null,"Pod",null,null,"Taro","West"]