{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Data","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Имя","Дата рождения ","Пол","список назначенных медикаментов","кол-во"]
[null,"иван","1979-06-03","м","Анальгин",4]
[null,null,null,null,"Баралгин",7]
[]
[]
[]
[null,null,null,null,null,null,null,"Макрос для копирования строк E3:F5"]
[null,null,null,null,null,null,null,"в случае если ",null,"эти строки заполены"]
[]
[]
[null,null,null,null,null,null,null,"продолжение действия макроса см на листе List"]

{"sheet":"List","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["N карточки","Имя","Дата рождения ","Пол","список назначенных медикаментов","кол-во"]
[344,"Петя","1987-12-11","м","анальги",5]
[{"$f":"IF(ISTEXT(B3),A2+1,\"\")","v":345},"Ваня","1987-12-12","м","баралгин",1]
[{"$f":"IF(ISTEXT(B4),A3+1,\"\")","v":346},"Саша","1976-02-02","м","димедрол",1]
[347,"Иван","1976-08-03","м","baralgin",10]
[348,"Иван","1976-08-03","м","персен",10]
[349,"Иван","1976-08-03","м","персен",10]
[350,"Иван","1976-08-03","м","персен",10]
[351,"иван","1979-06-03","м","Анальгин",4]
[351,"следющее имя вставляется сюда",null,null,"смекта",5]
["",null,null,null,"ренни",5,null,null,"после того как макрос скопировал данные с листа ДАТА нужно чтобы они размещались в правильном порядке"]
["",null,null,null,"фалиминт",5,null,null,"все работае, но что если в листе дата было указано больше чем "]
[352,"следющее имя вставляется сюда",null,null,"другое лекарство",10]
[353,"следющее имя вставляется сюда",null,null,"еще одно лекарство",2]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]