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: