@Pauley

Yeah the thing is ITS WEIRD wahaha.. When I started filtering some records are automatically hidden. The workaround that I did is every time I will filter the table I will convert it to range and if I will enter a new record I switch it back to table but thanks for looking into it.