Good day all
I have a table on a worksheet with two columns (name/ID). each column has a drop downlist data. I want to filter one column by using other drop down list.
for example when I choose a name from list in the column (name) must the other column filterd to match the selection.