{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист2_исходникПеред"],"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":"Лист1","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"MATCH(A1,Лист2!$A:$A,0)","v":1}]
[2,{"$f":"MATCH(A2,Лист2!$A:$A,0)","v":2}]
[3,{"$f":"MATCH(A3,Лист2!$A:$A,0)","v":3}]
[4,{"$f":"MATCH(A4,Лист2!$A:$A,0)","v":5}]
[5,{"$f":"MATCH(A5,Лист2!$A:$A,0)","v":6}]
[6,{"$f":"MATCH(A6,Лист2!$A:$A,0)","v":7}]
[7,{"$f":"MATCH(A7,Лист2!$A:$A,0)","v":8}]
[8,{"$f":"MATCH(A8,Лист2!$A:$A,0)","v":9}]
[9,{"$f":"MATCH(A9,Лист2!$A:$A,0)","v":10}]
[10,{"$f":"MATCH(A10,Лист2!$A:$A,0)","v":11}]
[11,{"$f":"MATCH(A11,Лист2!$A:$A,0)","v":12}]
[12,{"$f":"MATCH(A12,Лист2!$A:$A,0)","v":13}]
[13,{"$f":"MATCH(A13,Лист2!$A:$A,0)","v":14}]
[14,{"$f":"MATCH(A14,Лист2!$A:$A,0)","v":15}]
[15,{"$f":"MATCH(A15,Лист2!$A:$A,0)","v":16}]
[16,{"$f":"MATCH(A16,Лист2!$A:$A,0)","v":17}]
[17,{"$f":"MATCH(A17,Лист2!$A:$A,0)","v":18}]
[18,{"$f":"MATCH(A18,Лист2!$A:$A,0)","v":19}]
[19,{"$f":"MATCH(A19,Лист2!$A:$A,0)","v":20}]
[20,{"$f":"MATCH(A20,Лист2!$A:$A,0)","v":21}]
[21,{"$f":"MATCH(A21,Лист2!$A:$A,0)","v":24}]
[22,{"$f":"MATCH(A22,Лист2!$A:$A,0)","v":25}]
[23,{"$f":"MATCH(A23,Лист2!$A:$A,0)","v":26}]
[24,{"$f":"MATCH(A24,Лист2!$A:$A,0)","v":27}]

{"sheet":"Лист2","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[-1]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[-25]
[-26]
[21]
[22]
[23]
[24]
[]
[]
[]
[]
[null,null,"скопировать сюда колонку A c листа Лист2_исходникПеред"]
[null,null,"нажать Alt+F8 и запустить макрос sync"]
[null,null,null,"новые элементы списка, подтянутые с Лист1"]
[null,null,null,"элементы \"К удалению\" (отсутствующие на Лист1)"]

{"sheet":"Лист2_исходникПеред","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[3,null,"скопировать отсюда колонку A и вставить на Лист2"]
[-1]
[5]
[6]
[7]
[8]
[9]
[10]
[13]
[14]
[15]
[17]
[18]
[19]
[20]
[-25]
[-26]