Need macros in the Excel table

Employer
[no-member:pro]Andrey[/no-member:pro]Andrey
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
For example:
In the yach. A1 list of values (Data-Verification-List)
When choosing the value of_1 in a bar. B1 is substituted with List_1
When choosing the value of_2 in a bar. B1 is substituted List_2
When choosing the value of_N in the bar. B1 is substituted with List_N
All lists are named ranges.
In the yach. A1 list of values (Data-Verification-List)
When choosing the value of_1 in a bar. B1 is substituted with List_1
When choosing the value of_2 in a bar. B1 is substituted List_2
When choosing the value of_N in the bar. B1 is substituted with List_N
All lists are named ranges.