I have a question that I cant remember how to do. Would appriciate all the help I can get.


I have a cell in my worksheet where people can chose from a drop down list.
And after that choice i want to make a table where the top row is a duplication of the "chosen" row, meaning if the person choses Denmark in a list somewhere in the worksheet, the cells following "current choice" should list the number/strings of that choice.

CHOICE: Denmark



--------------------Currency---Size
Current choice----DKK----500
Sweden-------------SEK-----300
Norway-------------NKK------400
Denmark-----------DKK-------500


Can someone assist in this?
Thanks in advance!