Simple Question for a VBA Genius

[Jeff5019]

Hi,

Can't seem to find the answer to this one. I have a workbook in EX2007 with 2 sheets. I need something that will do the following.

If Sheet 1 Column A = Sheet 2 Column A AND Sheet 2 Column B > Sheet 1 Column B Then Copy Sheet 1 Column B to Sheet 2 Column B

This could potentially be in any row. Basically I have a cell with an account number in ColA on both sheets and I need to make sure that account number matches before it does anything. Then if it does match check the number in ColB and if the number is bigger on sheet 1 then copy that number to sheet 2 in the appropriate cell and row.

Any assistance would be very much appreciated.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=631898

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).