Looking For VBA Script which help to Populate the result by selecting Partner

Hi Fellow Members,

Hope you are in good in health and safe!

I have an query, i am looking for Code which help to populate the list of available model by qty and its value while selecting particular Partner from drop down list.

Drop Down list is working but i am not able to create codes.

Once i select any partner from drop down list, POP-up should appears with all the models listed with qty value and sum of qty/Value.

Reference data is attached.. Working sheet is : Summary where all the data is reflecting.

Thanks in advance.

Possibly this will meet your needs...

Hi,

Thanks for prompt reply.. File which you have shared, seems corrupted..Possible to re-share again?

Sir,

Really Sorry, File as well Code, both are not working..

I may be beating a dead horse here...

This in the worksheet's code module

Please Login or Register  to view this content.

...and this in a standard code module.

Please Login or Register  to view this content.

Thanks a lot for your time and patience. Both the things are working perfectly..