Add numbers dynamically down a column

Good day, Gurus.

In the attached sample workbook I am trying to add the vendor number down the column H for each PO. I have copied a few of the numbers into the column, (in red), to show the desired result. Basically, I will have a report daily with a variable number of suppliers, and variable PO's for each supplier. I need to add the vendor # to each row.

Thanks in advance for any help you can offer.

If this were automated, where would Excel be taking the Vendor # FROM to insert it into column H? Is it already in column B on that totals line?

Formulaically, just put this in H2 and copy down, the values will appear when you've copied, not when you enter the first formula.:

=IF(ISNUMBER(SEARCH("Totals",A2)),B2,H3)

hutch@edge.net,

See the attached workbook "Update Vendor - Open PO Sample - hutch at edge dot net - VP - SDG.xls" with the "UpdateVendor" macro.