I want to create a macro to do below.

Read the part number in BOM, It will replace the description if it sees toolbox hardware

E.g. You see below item #4, the part number is M5x14x14, ISO 4762, STEEL. I will need the macro to replace the description to "M5 SOCKET HEAD CAP SCREW - 14mm"

How to read the part number from BOM and edit the description?