Dear experts
I have data set which is for validation of error on both sheet build A and B, i need vba code to list validation so minimize by pick unique values Page,Testcase,Testid
i want shown values of testid once done unique validation of textbox3 from both sheet A and B
for e.g
"if i select page = ASIA In Listbox1 then listbox2 show all unique values towards ASIA, then
if i select testcase= CHINA in Listbox2 then Llistbox3 show all unique values towards china
in listbox3 show all testid ,then what Tet ID select in , result should pop up in both side Build A and Build B data range from sheetBuild A and Build B
A result start at range A19
B result start at range L19
Listbox1 Unique column of B:B
Listbox2 Unique column of C:C
Listbox3 Unique column of A:A depends upon TestID , Result values will be shown in data range of BUILD A AND BUILD B of BUILD A and BUILD B SHEET'S becoz Test id reflect in both sheet
Thanks and regards
find the attachment u understand what i actual looking for