{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Лист4","Лист5"],"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":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["№ заказа","ФИО","План"]
[1,"Петров",23]
[2,"Иванов",35]
[1,"Иванов",24]
[2,"Сидоров",26]
[1,"Сидоров",56]
[2,"Петров",47]

{"sheet":"Sheet2","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["№ заказа","ФИО","Факт"]
[1,"Петров",25]
[2,"Петров",36]
[1,"Сидоров",48]
[2,"Сидоров",23]
[1,"Иванов",56]
[2,"Иванов",54]
[1,"Васечкин",35]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист4","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["№ заказа","Заказчик","№ договора","Дата начала","Дата окончания"]
[1,"Вася","1-14-1567","2013-01-01","2013-12-01"]
[2,"Витя","23-43-256","2014-01-01","2014-12-01"]
[]
[]
[]
[]
["На другом листе макрос должен искать по № заказа и вставлять данные в таблицу, на листе 5"]
["только выборку по ячейкам строки делает по числу из ячейки А2 листа 5."]
["Вся загвоздка в наименовании заказчика и номере договора. "]
["Даты сделала через формулу СУММЕСЛИ, но она не работает при нечисловом формате."]

{"sheet":"Лист5","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["№ заказа","Заказчик","№ договора","Дата окончания"]
[1,"Вася","1-14-1567",{"$f":"SUMIF(Лист4!A2:A3,Лист5!A2,Лист4!E2:E3)","v":"2013-12-01"}]