Hi Experts (All worksheets same workbook)
Need a macro the well run after the data selection has been made from validation list on cell d18, worksheet "ABC"
Click macro button then >
Populate results into table below same worksheet:-
Data table on worksheet "ABC" d22:d42
The result are pull back from worksheet "data" so look in column z which corresponds to the selection made from the data validation list cell d18 worksheet "ABC"
And return the results back from Column AB....which goes into range D22:42 in above table and values are text...
Here the tricky bit only unique values...