Hi Guy,

i am after a VBA code which based on 2 lots of selected criteria (from a data validation list/drop down list) will return the relevant rows.

I have a dashboard sheet which im looking to have 2 drop down selections

Week No
Percentage

Depending on what criteria the user selects the relevant rows from that sheet (Named Week1, week2, e.t.c) is returned that match the percentage required looking at.

for example.

If the user selects Week2 from the data validation list and 15% from the second data validation list, i am after a VBA code which looks at Week2 sheet and returns all rows with a percentage of 15% or less to the dashboard.

i tried recording a macro but i dont know what the function is to search for specific sheet based on selection the macro just always looks at the recorded sheet and the Percentage i filtered.

Thanks