Transfer row if criteria met

[Jewels90]

I have a table in 'Expense Entry' sheet A28:F500, which if Column E=Bank Account, would like to transfer each & every complete row to new worksheet. What formula do I enter please

 

[PCosta87]

Hi and welcome to the forum

There are multiple ways of doing this but the simplest one would be to filter by "Bank Account" in column E and then copy the entire range to the desired destination... this will only copy the rows that are visible, which means only those matching the criteria.

Hope this helps