Hello,

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.

Thanks

Zack