You can apply a sheet filter directly to the sheet. Click on the sheet settings button on edit mode to do so.

HI Noel,can you suggest how to pass the selected drop down value to the sheet filter logic.Similarly I have 8 dropdowns in the sheet1 which shouldbe applicable(filtering the data) to sheet1 only not for the other sheets

Hi Vinod,

please check into which variable each of your drop downs is writing your selections.

e.g Dropdown 1 writes into Variable A, Dropdown 2 writes into Variable B etc.

Now you need to change the filter logics in each Sheet e.g only Sheet 1 should apply the filters written into Variable A. Sheet 2 should apply the filters written into Variable B and so on.

With this setup you can make use of different dropdowns writing into different variables that are used as filters in different sheets.

BR

Dennis