Macro: Automatic copy data from another sheet with condition checking date

I want to make macro (or VBA) for automatic copy data, and I'm new in this (just start to learn).

Here the data that i have:
sheet : List Cust

Cust	Entry Date	Term
A	01-01-12	4
B	01-01-12	3
A	04-01-12	5
C	02-01-12	7
D	08-01-12	6

sheet : transaction

Cust	Trans Date	Term
A	02-01-12	4
B	03-01-12	3
A	05-01-12	5

As you see, in sheet transaction, field term are from sheet 'list cust' with condition If Cust = 'A' and Max(Entry Date) <= Trans Date then copy the term to sheet transaction, so far i used formula like this :

Please Login or Register  to view this content.

Thanks in advance
SDCh

I'll try to record macro and this the result:

Please Login or Register  to view this content.

Can someone help me, so I can run this code on VBA automatically, because i got error message "Run-time error '1400': Application-defined or object-defined error"

And if can, I want the looping using "For Next".


Thanks in advance
SDCh