Writing a macro for Excel

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.