{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[2,null,null,null,null,null,"Подскажите как сделать так что бы при изменении значения в поле А1 добавлялся новый артикул и номер"]
[null,"Существующий",null,null,null,null,"При выборе 2 в поле А1 появляется возможность добавления нового артикула как на примере ну и при номере 3 появляется возможность добавления 3 артикула"]
["Новый номер","Новы1"]
["Новое название","Новый1"]
["Сущестующий1","Сущ1"]
["Название существующего1","Существ1"]
[]
["Новый номер2","Новы2"]
["Новое название2","Новый2"]
["Сущестующий2","Сущ2"]
["Название существующего2","Существ2"]
[]
["Новый номер3","Новы3"]
["Новое название3","Новый3"]
["Сущестующий3","Сущ3"]
["Название существующего3","Существ3"]
[]
[]
[null,null,null,"Private Sub worksheet_change(ByVal target As Excel.Range)"]
[]
[null,null,null,"If Not Intersect(target, Range(\"B2\")) Is Nothing Then"]
[null,null,null,"        With Sheets(\"Sheet1\")"]
[null,null,null,"            If target.Value = \"\" Then"]
[null,null,null,"                .Rows(\"3:6\").Hidden = True"]
[null,null,null,"            ElseIf target.Value = \"Новый\" Then"]
[null,null,null,"                .Rows(\"3:4\").Hidden = False"]
[null,null,null,"                .Rows(\"5:6\").Hidden = True"]
[null,null,null,"            ElseIf target.Value = \"Существующий\" Then"]
[null,null,null,"                .Rows(\"3:4\").Hidden = True"]
[null,null,null,"                .Rows(\"5:6\").Hidden = False"]
[null,null,null,"            End If"]
[null,null,null,"        End With"]
[null,null,null,"    End If"]
[null,null,null,"End Sub"]