Drop Down List that goes to a specific cell on the page when a specific item is clicked

Hi all,

I am using Excel 2010 and I have a worksheet where I need my end user to be able to go to a specific cell on the same worksheet when he chooses an item from that drop down list. How do I go about creating this? Is it feasible with formulas?

Let me explain the problem in detail: My drop down list will be in cell A2 (rows 1 and 2 will be freezed). When the user selects, say South Africa, from the drop down list, I want the worksheet to scroll downwards automatically and stop at cell A43 (which is where South Africa is located). The same will apply to the other items in the list.

I have attached an Excel sheet for better understanding of the problem.

Thank you for helping!

drop down list.xlsx

Thanks SixthSense! I will give it a try and see how it works! You gave me another idea with the "hyperlink" thing! :-)