I have the following data in A1 that has been pasted from another sheet
<tbody>
</tbody>
In VBA i would like to apply the formula (Vendor Score * Weight) * Points and update the Vendor Score so it looks like so
<tbody>
</tbody>
The other issue i have is that in Category it could be 4 or 10 or x number of criteria but the last row will always be Totals, likewise with Vendor 1 Score, there could be a number of vendors so Vendor 1 Score, Vendor 2 Score in columns ....
Any help would be awesome...my head hurts
Category | Description | Weight | Points | Vendor Score |
Criteria | Description of item 1 | 6% | 10 | 8 |
Criteria | Description of item 2 | 6.5% | 10 | 7 |
Criteria | Description of item 3 | 10% | 10 | 6 |
Criteria | Description of item 4 | 7% | 10 | 5 |
Totals |
<tbody>
</tbody>
In VBA i would like to apply the formula (Vendor Score * Weight) * Points and update the Vendor Score so it looks like so
Category | Description | Weight | Points | Vendor 1 Score |
Criteria | Description of item 1 | 6% | 10 | 4.8% |
Criteria | Description of item 2 | 6.5% | 10 | 4.55% |
Criteria | Description of item 3 | 10% | 10 | 6% |
Criteria | Description of item 4 | 7% | 10 | 3.5% |
Totals |
<tbody>
</tbody>
The other issue i have is that in Category it could be 4 or 10 or x number of criteria but the last row will always be Totals, likewise with Vendor 1 Score, there could be a number of vendors so Vendor 1 Score, Vendor 2 Score in columns ....
Any help would be awesome...my head hurts