Hi
I need to achieve the following.
Cells A1 to A5 have numeric values in them. I want to be able to select different combinations and display the total of the selected cells in A6 - eg A1+A3+A4 the first time, A2+A5 the second etc etc
I'm assuming I will need VBA to do this
Many thanks
I need to achieve the following.
Cells A1 to A5 have numeric values in them. I want to be able to select different combinations and display the total of the selected cells in A6 - eg A1+A3+A4 the first time, A2+A5 the second etc etc
I'm assuming I will need VBA to do this
Many thanks