VBA to compare 2 specific values in each row in two different sheets and highlight if match

[dannyboi1]

Hi I am new to this board and have been trying to write this code to help my friend but having some struggles with this code

Essentially I'm trying to check if the invoice and fee on Sheet1 match the ones input on Sheet2, there are other columns as well, but they do not need to match, also the invoices aren't necessarily in the same order on both sheets

I'm having a tough time with once we're able to match invoice, check that the fee matches for that invoice, not sure if it's a double if statement or how to proceed

Hoping someone can please help with a code for this where I can than edit it with the specifics of the worksheet cause I am very lost

Thanks in advance

 

[6StringJazzer]

what columns have the invoice and the fee on sheet1, and what columns have the invoice and the fee on sheet2?

What kind of result do you want?

BTW you do not need VBA for this unless you need some kind of fancy report.

 

[dannyboi1]

what columns have the invoice and the fee on sheet1, and what columns have the invoice and the fee on sheet2?

What kind of result do you want?

BTW you do not need VBA for this unless you need some kind of fancy report.

For Sheet 1: Column B has Invoice and Column H has fee/expense
For Sheet 2: Column B has Invoice and Column I has fee/expense
Result: I'd say highlight the matches on Sheet 2

I thought VBA would be the best way about it, but if there's a better easier way, I'm open to it!

 

[6StringJazzer]

In sheet2 use conditional formatting. Select all columns you want this apply to (entire columns) and add this conditional formatting rule:

=$I1=INDEX('Sheet 1'!$H:$H,MATCH($B1,'Sheet 1'!$B:$B,0))

with desired highlight formatting

Double check sheet names and update formula to match the actual sheet name if it is not "Sheet 1".

This will highlight rows in sheet 2 where the invoice number on sheet 1 has a different fee/expense than what is on sheet 2.

This assumes that Invoice in B is unique.

 

[dannyboi1]

In sheet2 use conditional formatting. Select all columns you want this apply to (entire columns) and add this conditional formatting rule:

=$I1=INDEX('Sheet 1'!$H:$H,MATCH($B1,'Sheet 1'!$B:$B,0))

with desired highlight formatting

Double check sheet names and update formula to match the actual sheet name if it is not "Sheet 1".

This will highlight rows in sheet 2 where the invoice number on sheet 1 has a different fee/expense than what is on sheet 2.

This assumes that Invoice in B is unique.

wow this was a lot easier than I was making it haha. And I was able to edit it to work exactly for my code - thank you so much for the help, I really appreciate it!!

 

[6StringJazzer]

Glad to help!