Thanks for quick response,

But for some reason Filter function is not working for me. is there any alternative.





On Thursday, 2 April 2020 16:55:31 UTC+5:30, GS wrote:
Hi,

I have a list of Pincodes, Area, City and State names. (Total rows are some
150000)

Now, when i select Pincode, in the next column, i need Area to be a drop down
which is generate dynamically based on pincode selected.

Can you guys please help me.

Thanks
Anil Hungund.

See here...

https://www.contextures.com/exceldat...nddynamic.html

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion