Apologies if this has already come up but I’m at a complete loss.

I have to work books - RS CONTRACT MANAGEMENT BOOK & CONTRACT EXTENSIONS.

I need a macro that will look at data from one and paste another column where the criteria has been satisfied.

For Example:

In CONTRACT EXTENSIONS look at the Contract Customer Name ($D$5, $D$6, $D$7 etc...) & Contract No ($C Matching Row).
Look in the RS CONTRACT MANAGEMENT BOOK and find the row that matches the Contract Customer Name ($B$5 etc...) & Contract No ($E Matching Row) criteria.
If both are satisfied, copy the Contract Extension Date ($E Whatever determined row)& Contract Extension No ($F Whatever determined row) from CONTRACT EXTENSIONS and paste it in to the End Date ($M Whatever determined row) & No of Extensions ($N Whatever determined row) in RS CONTRACT MANAGEMENT BOOK.

(Sorry if that is confusing, I know how you feel)

To be honest, I have a deadline on this so the complete code would be greatly appreciated!

Thanks in advance,
Adam.