Refresh automaticly filter and hide rows based on empty cells when change criteria

[maabadi]

Hi
I have a criteria in cell B2 and have a table from A8:I22.
I write formula on column C when the Column F and I is Zero, show it Empty.
I filtered data based on column C (Header Name = Year) and Hide table Rows based empty cells on Column C.
I Want when I change Criteria on cell B2 and change Empty Cells On column C, All table refreshed and table show only Rows have values on Column C and Hide Empty Cells. (macro, VBA , Formula or Autofilter)

thanks