{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"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":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,4,0],[2,1,4,1]]}
["                 Find Value in Column Using FIND Function in VBA"]
[]
["Find Order ID For this Product ID","AP-1100",null,"Match Order ID"]
[]
[]
[null,"                                           Products Information"]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["                  Find Value From Different Worksheet in Excel VBA"]
[null,"                                           Products Information"]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"Sheet3","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,4,1],[2,2,4,2]]}
["             Find Value From Different Worksheet in Excel VBA"]
[]
[null,"Find Order ID For this Product ID","AP-1177",null,"Match Order ID"]
[null,null,null,null,"F-420"]

{"sheet":"Sheet4","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["                                     Find and Mark Value in Column in Excel VBA"]
[null,"                                                   Products Information"]
[null,"Product ID","Brand","Model","Unit Price","Order ID","Delivery Status"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551","Delivered"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651","Delivered"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554","Delivered"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555","Processing"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657","Pending"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454","Processing"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420","Processing"]
[null,"OP-1188","ONEPLUS",8,450,"A-588","Pending"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599","Delivered"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330","Delivered"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890","Pending"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120","Processing"]

{"sheet":"Sheet5","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,2,19,2],[17,3,19,3]]}
["                                      Find Values in Column Using Wildcards in Excel VBA"]
[null,"                                                                Products Information"]
[null,"Product ID","Brand","Model","Unit Price","Order ID","Delivery Status"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551","Delivered"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651","Delivered"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554","Delivered"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555","Processing"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657","Pending"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454","Processing"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420","Processing"]
[null,"OP-1188","ONEPLUS",8,450,"A-588","Pending"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599","Delivered"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330","Delivered"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890","Pending"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120","Processing"]
[]
[]
[null,null,"Find Price For this Product ID",1199,null,"Price"]
[null,null,null,null,null,550]