I’m not sure if the select all difference matters, as I cannot seem to reproduce your issue either way.
Have you added any new columns to the Transactions sheet? Any check boxes?
I can reproduce your issue if a column has check boxes. The filter range does not auto-expand with a new row added with data.
![]()
The data filter does auto-expand when the check box is not present.
![]()
Note that the default Fill will append rows to the Transactions sheet and sort them to the top by descending Date, as opposed to inserting them at the top.