Hi there,

I am new to VBA and now have a bank rec with matching items by the reference but with a different date, therefore the list is always getting bigger.

Is there a easy way to match off items from 2 lists in one tab?

e.g. Date in column A, reference in column B, amount in column C for 1 list
Date in column E, refererence in column F, amount in column G for list comparing the above 2.

The references should be the same.

Ideally it would be nice to match of the items and move them to another tab?

Is this possible? Your help would be much appreciated.

Regards