Hello everyone!
I know excel well, but I don't know vba. I would be grateful for any help.
Based on the table (М-55 МP) i need to use any tool to build a module that, when checking a product line with options, would automatically display its production date.
Line to check - M-55-DI-516-MP-t1-050-10MPa-42-C
An example of outputting the result-
I know excel well, but I don't know vba. I would be grateful for any help.
Based on the table (М-55 МP) i need to use any tool to build a module that, when checking a product line with options, would automatically display its production date.
Line to check - M-55-DI-516-MP-t1-050-10MPa-42-C
An example of outputting the result-
| Qty to: | Order line | Lead time (working days) |
| 5 | M-55-DI-516-MP-t1-050-10MPa-42-C | 10 |
| М-55 МP | Qty to: | Lead time (working days) | |||||||||
| Model | Oxygen version | Electronic converter | Climatic version | Basic permissible error limit | Upper measurement limit | Output signal | bracket | Mounting parts | Additional options | ||
| 515, 516, 517 | t1, t8, t10, t11 | 015, 025, 050 | any | 4-20 | M20 | Вн, Ex, С | 2 | 5 | |||
| 515, 516,517,535 | t1, t8, t10, t11 | 015, 025, 050 | any | 4-20 | M20 | ВН, Ех, С, QM, ST, | 15 | 10 | |||
| 518, 528 | 5 | ||||||||||
| 505, 506 | 5 | ||||||||||
| С2, SHR1 | 10 | ||||||||||
| M12 | 5 | 25 | |||||||||
| K | any | 5 | 22 | ||||||||
| Kp | 5 | 10 |
