Hello everyone!
I know excel well, but I don't know vba. I would be grateful for any help.
A table with a set of options for a product is given, defining its production date.
It is necessary to write a module that would automatically output its Order fulfillment time when checking a Order line with options. For example:
From this table:
I know excel well, but I don't know vba. I would be grateful for any help.
A table with a set of options for a product is given, defining its production date.
It is necessary to write a module that would automatically output its Order fulfillment time when checking a Order line with options. For example:
m.xlsm | |||||
---|---|---|---|---|---|
B | C | D | |||
18 | Quantity | Order line | Order fulfillment time | ||
19 | 5 | M-55-D-516-MP-t1-050-10MPa-42-C | 10 | ||
M-55 |
From this table:
m.xlsm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | M-55 MP | Quantity | Order fulfillment time | |||||||||||
2 | model | Oxygen version | Электронный преобразователь | Electronic converter | Limit of basic permissible error | Upper limit of measurement | Output signal | bracket | Mounting parts | Additional options | ||||
3 | ||||||||||||||
4 | 515, 516, 517 | t1, t8, t10, t11 | 015, 025, 050 | any | 4-20 | M20 | Вн, Ex, С | 2 | 5 | |||||
5 | ||||||||||||||
6 | 515, 516,517,535 | t1, t8, t10, t11 | 015, 025, 050 | any | 4-20 | M20 | ВН, Ех, С, QM, ST, | 15 | 10 | |||||
7 | 518, 528 | 5 | ||||||||||||
8 | 505, 506 | 5 | ||||||||||||
9 | C2, SH | 10 | ||||||||||||
10 | M12 | 5 | 25 | |||||||||||
11 | K | any | 5 | 22 | ||||||||||
12 | Кр | 5 | 10 | |||||||||||
13 | any | any | 0-5 | any | - | |||||||||
M-55 |