Display only Rows and Column (a sort of filtering)

[lemuel]

Hi Everyone,

I am looking for a solution for filtering out values. Does this could be possible for excel functions or Macro codes?

See attached file. I had offer names place on single page with corresponding stats. Now I just wanted to filter out/ just display only the offer stats (rows) when selecting the equivalent values on the dropdown list. example if i select Offer 7 - then just display the Offer 7 rows and column other offers are hidden. Could this be possible?