Writing a macro for Excel

Employer
[no-member:pro]Dmitry[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer
Acceptance of requestsfrom Oct 1, 2020 until Oct 5, 2020
Project description
The services of a macros specialist for Excel are required. We need to write a macro. There is a file with a list of devices distinguished by number and type of device.
The employee makes a statement, which device is installed where. It is necessary that when filling the number in the statement (the last 6 digits from the equipment number) in the neighboring graphs from the supply list, the full number and type of the device were pulled up, the location of the rows and columns were fixed, but it was possible to color them, hide them, add lines.
The employee makes a statement, which device is installed where. It is necessary that when filling the number in the statement (the last 6 digits from the equipment number) in the neighboring graphs from the supply list, the full number and type of the device were pulled up, the location of the rows and columns were fixed, but it was possible to color them, hide them, add lines.