2003 excell drop down help

[concretegod40]

I was wondering if someone could help me. Rermember I am 57 years old & basically computer illeterate!
I have a spreadsheet for a baseball program in excell 2003...
What I have is a list of baseball teams with formulas for at bats  on worksheet #2 & I have a formula
(=COUNTIF(S2:S32,"?*") on worksheet page one which shows the list of teams. When I try to create a drop
down window to change lineups from one team to another on page one it changes the team name in drop down window but not the teams formula results. Does this make sense? Please let me know! Thank you!

[Allan]

Please do not post the same question more than once.  Thank you.

I deleted the duplicate.

[concretegod40]

sorry thought i posted it in the wrong place.

[Allan]

Nope - it's fine right here. Thanks.