Hi experts
i have 2 set of matching total profit from sheet (Green and Orange)
i have userform i need vba code to execute these actions
need to validate Drop down list that covers two correspoding columns for listbox1 and 2 for 3
if i select region = ASIA In Listbox1 then listbox2 show all unique values towards ASIA, then
if i select country= CHINA in Listbox2 then Llistbox3 show all unique values towards china
in listbox3 show all Order ID ,then what Order ID select in , result should pop up in both side 3 textboxes green and oranges
Listbox1 Unique column of B:B
Listbox2 Unique column of C:C
Listbox3 Unique column of A:A depends upon Order ID , Result values will be shown in 3 textbox of green and orange becoz order id reflect in both sheet
check sheet view to understand my requirement
click_G for userform
Thanks and regards
Bookmarks