Hi Guys,
Sorry for the Late Reply.
Had some stuff I had to take care of which didn't allow me to look into this matter.
This time it somewhat gives a solution but not without a new catch.
When I start to type the Drop-Down opens up but doesn't get update then and there as I type in.
But let's say I got an agent name partially right,
If I stop typing it ( While the Drop-Down remains the same ) click another cell and try to continue type again,
Then the Drop-Down opens up with the updated set of Data.
Why is that?