Hi Guys / Gals

This is what I'm attempting to do in Office : Create a table with a dropdown list box with various selections in Cell A1 and in B1 the cell will reflect the changes in cell A1

ie: Cell A1 Cell B1
Make selection here Price change here

Now, depending on selection in cell A1 dynamically changes the price in call B1

How can this be done and also keep a running total at the bottom.

If you can't answer my question, can you please point me in a direction or web page that may have some helpful tips.

Thanks in advance.