Excel 2007 : Formulas in drop down list

I have created a calendar for work that will automatically deduct used PTO from the beginning of the years balance. Now to make things easier for those using the calendar I have created 4 different cells containing basically the same formula with one variable that is different, the amount of hours available at the beginning of the year. The calculations work but when you direct the drop down box to pick one of the four formulas it does not update the data until you pick the drop down every time. I was hoping that once the choice was made the calculations would update but it does not. This is my first posting so please let me know what other info is needed. Thanks for all those that read this.

Not sure I follow 100% but first check that you have Automatic Calculations on.. go to Formula menu, Calculation, Automatic should be selected....

If that isn't it, can you post a sample of what you mean?

I see what you mean now... unfortunately the data validation doesn't work that way. It doesn't recognize the actual cell you chose and so doesn't update correspondingly... once a choice is made, it becomes static... you might use another cell adjacent perhaps to indicate a change?

You can use a ComboBox instead

See attached

This is found in the Developer tab, click Insert in the Controls section and pick the combobox from the Form Controls section. Draw the control in the cell.

Then right-click, select Properties, in the Control tab enter the Input Range, enter a Cell link, click Ok. Now the numbers update with changes...

Great. Glad that works for you...

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save