Hi All,

I've had a browse and i can't seem to find this example. I've found examples of codes summing the numbers within the cell but nothing that i can find relating to finding the numbers within the cell seperated by either commas, slashes, etc - linking them back to a table or a list and summing numbers attached.

Basically;

Find all numbers in D2 (A1, A4, A5)

Sum relevant numbers in E2 (B2, B4, B5)

<tbody>

</tbody>

Unfortunately i've got a very limited VBA understanding, and i hope I've made it easy to understand where I'm getting at

Haddy

I've had a browse and i can't seem to find this example. I've found examples of codes summing the numbers within the cell but nothing that i can find relating to finding the numbers within the cell seperated by either commas, slashes, etc - linking them back to a table or a list and summing numbers attached.

Basically;

Find all numbers in D2 (A1, A4, A5)

Sum relevant numbers in E2 (B2, B4, B5)

A | B | C | D | E |

1 | 100 | Total | ||

2 | 30 | 2,4,5 | ||

3 | 20 | |||

4 | 15 | |||

5 | 25 |

<tbody>

</tbody>

Unfortunately i've got a very limited VBA understanding, and i hope I've made it easy to understand where I'm getting at

Haddy

Last edited: