Excel VBA - Pass value to Specific Table Row & Column

With reference to the code below I am trying to amend the values in the 14th column in table "tbPartnerList". The values in this column vary with each table row. I wish to search for the value in Column 1 of the table on sheet ws2. When found I would like to return the associated value from column34 on sheet ws2 to the current row and the 14th column in the table.

The code below finds the appropriate value from column 34 on sheet ws2 but I am struggling to pass this value back to the table row / column 14.

Please Login or Register  to view this content.