{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Электроэнерг","ГАЗВОДА","Данные","Шпаргалка"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Электроэнерг","index":0,"n_rows":10,"n_cols":28,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[0,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,"Дата"]
[null,"№","Объект",null,"2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","С новыми","Разница",null,null,null,"Нов. Апрель",null,null,null,null,null,null,null,"Общ.зоны"]
["Электичество",1,"уч.25.2 Александров В.С.","Александров Виктор Степанович",32800,33007,33193,45,176,356,402,460,586,762,{"$f":"(INDEX(3:3,COLUMN()-1))+T3","v":762},{"$f":"(INDEX(3:3,COLUMN()-1)-INDEX(3:3,COLUMN()-3))","v":176},null,"нов 45"]
["Электичество",2,"уч.26.2 Иванова ЛВ","Иванова Лидия Владимировна",5580,5580,5580,0,8,8,8,51,61,61,{"$f":"(INDEX(4:4,COLUMN()-1))+T4","v":61},{"$f":"(INDEX(4:4,COLUMN()-1)-INDEX(4:4,COLUMN()-3))","v":0},null,"нов 0"]
["Электичество",3,"уч.28.2 Петров Т.М.","Петров Тимофей Михайлович (уч.1-5)",null,null,null,null,0,54,74,112,294,714,{"$f":"(INDEX(5:5,COLUMN()-1))+T5","v":714},{"$f":"(INDEX(5:5,COLUMN()-1)-INDEX(5:5,COLUMN()-3))","v":420}]
["Электичество",4,"уч.28.2 Сидоров А.А.","Сидоров Андрей Александрович",30233,30834,31361,481,952,1375,1674,2062,2564,3066,{"$f":"(INDEX(6:6,COLUMN()-1))+T6","v":3066},{"$f":"(INDEX(6:6,COLUMN()-1)-INDEX(6:6,COLUMN()-3))","v":502}]
["Электичество",5,"уч.33.1 Симонова Е.А.","Симонова Екатерина Александровна",8450,11769,652,3316,5299,5796,5925,6109,6443,6645,{"$f":"(INDEX(7:7,COLUMN()-1))+T7","v":6645},{"$f":"(INDEX(7:7,COLUMN()-1)-INDEX(7:7,COLUMN()-3))","v":202},null,"нов 652"]
[null,null,"ИТОГО",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P8+T8","v":1300},{"$f":"SUMIF(P3:P7,\">0\",P3:P7)-SUMIFS(P3:P7,P3:P7,\">0\",Q3:Q7,\"К вычету!\")","v":1300},null,null,null,{"$f":"SUM(T3:T7)","v":0}]
[null,null,"МОЭСК",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J9+T9","v":0}]
[null,null,"Потери и разница съемки по дням",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O9-O8","v":-1300},{"$f":"P8-P9","v":1300}]

{"sheet":"ГАЗВОДА","index":1,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[0,null,null,1,2,3,4,5,"Дата"]
[null,"№","ГАЗ",null,"2022-09-01","2022-10-01","С новыми","Разница",null,null,null,null,null,null,null,null,null,null,null,"Общ.зоны"]
["Электичество",1,"уч.25.2 Александров В.С.","Александров Виктор Степанович",156,762,{"$f":"(INDEX(3:3,COLUMN()-1))+L3","v":762},{"$f":"(INDEX(3:3,COLUMN()-1)-INDEX(3:3,COLUMN()-3))","v":606}]
["Электичество",2,"уч.26.2 Иванова ЛВ","Иванова Лидия Владимировна",12,61,{"$f":"(INDEX(4:4,COLUMN()-1))+L4","v":61},{"$f":"(INDEX(4:4,COLUMN()-1)-INDEX(4:4,COLUMN()-3))","v":49}]
["Электичество",3,"уч.28.2 Петров Т.М.","Петров Тимофей Михайлович (уч.1-5)",523,714,{"$f":"(INDEX(5:5,COLUMN()-1))+L5","v":714},{"$f":"(INDEX(5:5,COLUMN()-1)-INDEX(5:5,COLUMN()-3))","v":191}]
["Электичество",4,"уч.28.2 Сидоров А.А.","Сидоров Андрей Александрович",1986,3066,{"$f":"(INDEX(6:6,COLUMN()-1))+L6","v":3066},{"$f":"(INDEX(6:6,COLUMN()-1)-INDEX(6:6,COLUMN()-3))","v":1080}]
["Электичество",5,"уч.33.1 Симонова Е.А.","Симонова Екатерина Александровна",1322,6645,{"$f":"(INDEX(7:7,COLUMN()-1))+L7","v":6645},{"$f":"(INDEX(7:7,COLUMN()-1)-INDEX(7:7,COLUMN()-3))","v":5323}]
[null,null,"ИТОГО",null,null,null,{"$f":"H8+L8","v":7249},{"$f":"SUMIF(H3:H7,\">0\",H3:H7)-SUMIFS(H3:H7,H3:H7,\">0\",I3:I7,\"К вычету!\")","v":7249},null,null,null,{"$f":"SUM(L3:L7)","v":0}]
[]
[null,"№","ВОДА",null,"2022-09-01","2022-10-01","С новыми","Разница"]
[null,1,"уч.25.2 Александров В.С.","Александров Виктор Степанович",1245,2200,{"$f":"(INDEX(11:11,COLUMN()-1))+L11","v":2200},{"$f":"(INDEX(11:11,COLUMN()-1)-INDEX(11:11,COLUMN()-3))","v":955}]
[null,2,"уч.26.2 Иванова ЛВ","Иванова Лидия Владимировна",12,15,{"$f":"(INDEX(12:12,COLUMN()-1))+L12","v":15},{"$f":"(INDEX(12:12,COLUMN()-1)-INDEX(12:12,COLUMN()-3))","v":3}]
[null,3,"уч.28.2 Петров Т.М.","Петров Тимофей Михайлович (уч.1-5)",555,666,{"$f":"(INDEX(13:13,COLUMN()-1))+L13","v":666},{"$f":"(INDEX(13:13,COLUMN()-1)-INDEX(13:13,COLUMN()-3))","v":111}]
[null,4,"уч.28.2 Сидоров А.А.","Сидоров Андрей Александрович",645,777,{"$f":"(INDEX(14:14,COLUMN()-1))+L14","v":777},{"$f":"(INDEX(14:14,COLUMN()-1)-INDEX(14:14,COLUMN()-3))","v":132}]
[null,5,"уч.33.1 Симонова Е.А.","Симонова Екатерина Александровна",1888,2222,{"$f":"(INDEX(15:15,COLUMN()-1))+L15","v":2222},{"$f":"(INDEX(15:15,COLUMN()-1)-INDEX(15:15,COLUMN()-3))","v":334}]
[null,null,"ИТОГО",null,null,null,{"$f":"H16+L16","v":1535},{"$f":"SUMIF(H11:H15,\">0\",H11:H15)-SUMIFS(H11:H15,H11:H15,\">0\",I11:I15,\"К вычету!\")","v":1535},null,null,null,{"$f":"SUM(L11:L15)","v":0}]

{"sheet":"Данные","index":2,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["ФИО","ЭЛЕКТРОЭНЕРГИЯ","ГАЗ","ВОДА"]
["Александров Виктор Степанович",176,null,null,606,null,null,null,null,null,null,null,null,null,null,176]
["Иванова Лидия Владимировна",0,null,null,49,null,null,null,null,null,null,null,null,null,null,3172]
["Петров Тимофей Михайлович (уч.1-5)",420,null,null,191,null,null,null,null,null,null,null,null,null,null,133]
["Сидоров Андрей Александрович",502,null,null,1080,null,null,null,null,null,null,null,null,null,null,357]
["Симонова Екатерина Александровна",202,null,null,5323,null,null,null,null,null,null,null,null,null,null,755]

{"sheet":"Шпаргалка","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"https://exceltrick.com/formulas_macros/vlookup-in-vba/",null,"БЫЛО:"]
[]
[null,null,"Суб ADDCLM ()\nOnОшибка Resume Следующая\nDim Dept_Row Как долго\nDim Dept_Clm Как долго\nТаблица1 - =Sheet1.Range (\"A3:A13\"\"A3:A13\") ' Employee_ID Колонка из таблицы сотрудников\nТаблица2 _ =Sheet1.Range (\"H3:I13\"\"H3:I13\") ' Диапазон таблицы сотрудников 1\nDept_Row - Sheet1.Range (\"E3\").Row ' Измените E3 с помощью ячейки с того места, где вам нужно заполнять Департамент\nDept_Clm - Sheet1.Range (\"E3\").Column\nДля каждого cl в таблице1 \nSheet1.Cells (Dept_Row, Dept_Clm) - Application.WorksheetFunction.VLookup, Table2, 2, False) \nDept_Row - Dept_Row + 1\nСледующий cl\nMsgBox \"Сделано\"\nКонец Суб"]
[null,null,null,"СТАЛО:"]
[null,null,"Sub ADDCLM()\nOn Error Resume Next\nDim Dept_Row As Long\nDim Dept_Clm As Long\nTable1 = Sheet1.Range(\"A3:A13\") ' Employee_ID Column from Employee table\nTable2 = Sheet1.Range(\"H3:I13\") ' Range of Employee Table 1\nDept_Row = Sheet1.Range(\"E3\").Row ' Change E3 with the cell from where you need to start populating the Department\nDept_Clm = Sheet1.Range(\"E3\").Column\nFor Each cl In Table1\n Sheet1.Cells(Dept_Row, Dept_Clm) = Application.WorksheetFunction.VLookup(cl, Table2, 2, False)\n Dept_Row = Dept_Row + 1\nNext cl\nMsgBox \"Done\"\nEnd Sub"]
[]
[]
[null,null,"Вопросы - а если диапазон большой = не H3-I13, А например H3-R13, т.е. еще много столбов сравнения, как выбрать его?"]