If you can record the steps of using the dropdown and picking the value, you should just be able to put the values into the active data and replace the value with the active data link. You have to be careful to spell them exactly and be case sensitive too though
Accepted Guys @ Ya I got that ... In normal case i couldn't use visual test to do that ! Instead i used testscript and in the field where the dropdown appears i used TextSelect ( Active Data ) , that goes as a sky walk , feels great now !
In any case we couldn't use active data or any other datadriven approach as such , in some cases a bit of programming is required .