{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Column1","Column2"]
["COM3"]
["COM1\nCOM2"]
["COM1\nCOM4"]
[]
[]
["Cell A5 was the last populated (with COM3 and therefore all selections available in Column B are only applicable to COM3).  Can the code be change so that if B2 was selected it would in this example show the options from COM1 & COM2 not COM3."]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":26,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Options",null,"COM1","COM2","COM3","COM4","COM5",null,null,null,"COM 3 - 1. Option 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COM3"]
["COM1",null,"COM 1 - 1. Option 1","COM 2 - 1. Option 2","COM 3 - 1. Option 3","COM 4 - 1. Option 4","COM 5 - 1. Option 5",null,null,null,"COM 3 - 2. Option 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COM4"]
["COM2",null,"COM 1 - 2. Option 2","COM 2 - 2. Option 3","COM 3 - 2. Option 4","COM 4 - 2. Option 5","COM 5 - 2. Option 6",null,null,null,"COM 3 - 3. Option 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COM5"]
["COM3",null,"COM 1 - 3. Option 3","COM 2 - 3. Option 4","COM 3 - 3. Option 5","COM 4 - 3. Option 6","COM 5 - 3. Option 7",null,null,null,"COM 3 - 4. Option 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
["COM4",null,"COM 1 - 4. Option 4","COM 2 - 4. Option 5","COM 3 - 4. Option 6","COM 4 - 4. Option 7","COM 5 - 4. Option 8",null,null,null,"COM 3 - 5. Option 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
["COM5",null,"COM 1 - 5. Option 5","COM 2 - 5. Option 6","COM 3 - 5. Option 7","COM 4 - 5. Option 8","COM 5 - 5. Option 9"]