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?