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?