Stumped on 2 things...

[mungojeerie]

Hi there,
I need help with two things. I want to add a button to a excel sheet that when clicked preforms simple calculations (-/+)

A dumbded down version of my data is as follows:

<table width="192" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" width="64" height="17">Item</td> <td class="xl24" style="width: 48pt;" width="64">[+/-]</td> <td class="xl24" style="width: 48pt;" width="64">Total</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Apple</td> <td class="xl24">2</td> <td class="xl24">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Banana</td> <td class="xl24">-2</td> <td class="xl24">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Orange</td> <td class="xl24">2</td> <td class="xl24">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Pear</td> <td class="xl24">-2</td> <td class="xl24">5</td> </tr> </tbody></table>
The columns "Item" and "[+/-] will be on one worksheet and the Total column will be located on a different worksheet within the same workbook.

I want the button to when clicked add the value in [+/-] to the value in Total so that the the "Total" columns values would read then read as:

Item Total
Apple 7
Banana 3
Orange 7
Pear 3

and then at at later dates the values in the [+/-] column could be changed again but not effect the Total column until the button is pressed.

So... is it possible to do this addition/subtraction when one value of the formula is also the result cell?

And if so... how the heck do I do this??? haha

thank you in advance to taking the time to look at this.

Ryan

 

[mungojeerie]

VoG,
Thank you kindly.... it takes a long time - two and a half min to process 80 rows which is a bit annoying, but I can live with it.... it does what its supposed to do correctly so thank you again very much for taking the time to help me out.

Ryan