Simple Question for a VBA Genius

Status
Not open for further replies.

Jeff5019

New Member
Joined
Apr 27, 2012
Messages
15
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.
 
Status
Not open for further replies.

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top