I am attempting to write a macro that takes data from an excel file and populate several different custom properties. This seems to exceed the capabilities of the PTB because I am trying to drive the property population from a specific row. For example, part number is dictated by cell A1, and the material, PO number and other relevant properties are located in cells B1-H1. The idea would be to have the user define either the row or execute a search for a part number, which would then dictate what values to populate the custom properties with. I am relatively new to macros so any advice or closely related examples would help.