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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,046
Messages
5,569,852
Members
412,298
Latest member
dietitiann
Top