Hi, Im going crazy trying to figure this one out.

Does anyone know how to make a data range get automatically filtered based on what you select in a dropdown list?

Preferably, without using VBA or Macros, because I dont understand such advanced settings.

It's pretty urgent, so any help will be highly appreciated! thank you!