Help with creating an ADD button...

[Lyn Hall]

I am working with Excel 2007. I have this simple spreadsheet:


Selling Price: Editable field
Instructions: Drop down with Yes and No option (where option NO is #3 and
the else is the Yes or null value)

Trade Value: Calculated with this formula =IF(I4=3,(B5*0.3)-(B5*0.3)*0.3,
B5*0.3)

Now, I want to create a button that can be pressed (like an ADD button) that
when pressed it will take the value that comes up in the Trade Value
calculation and add it to another sheet that will automatically add it at the
bottom like a calculator.

I am a video game store trying to come up with my own method of used
trade-in values for use by my 10-year-old daughter to help determine Trade-in
Values based on our own criteria.

Is this possible or am I just hopeful?

 

[dustinbrearton via OfficeKB.com]

I am confused. The Sheet you have already figures out the trade in value for
a game and works? Are you trying to create a button that will take that
value along with some other information and put it on a second sheet to keep
a historical list of trade in values for games? The calculator part you
mention. Are you just wanting a running tally of the all the trade in values

 

[Lyn Hall]

Just a command button that will take that value from the first sheet (that
works) and copy it to sheet 2. This is what I need to do:

I need to be able to click the ADD button after each value and be able to
reset it back to zero. On the second sheet, I need it to add the cells in
that particular column, for example if I had three trade-ins worth $3.50,
4.60 and 2.90. We need to fill in the info for the first one that comes up
with $3.50 that is in Cell C10 click the add button and it copy it (just the
value) to sheet 2 (A1), delete the value in the Selling price field so we can
get the new value of 4.60, that needs to be copied to Cell A2 on Sheet 2 and
so on, but having a sum at the bottom at around A20.

Thanks!