Vlookup Looping through columns and rows returning sum in total column

[edp428]

First, I would like to thank anyone who can possibly assist me with the VBA for this spreadsheet.

The worksheet consists of 10 columns (A-J) and 13 rows (1-13). The first row is a header row that contains eight codes that I need to look up the value in a table and multiple it by the count in each of the cells below. The result of the vlookup for each column needs to be added together and return a total in column J. I have a formlua that works well, however, I would like to convert the formula to VBA and For Each loops confuse me every time. The formula is:

Please Login or Register  to view this content.

A sample workbook is attached.

Any help is greatly appriciated.

Thank you,
Eric

[Bernie Deitrick]

Here are two macros - one using your formula, the other using a loop:

Please Login or Register  to view this content.

[edp428]

Macro 2 is perfect, thank you! I really appriciate your help.

[Bernie Deitrick]

Great! Happy that you liked it...