cross comparing on a spreadsheet not finding values

**mdnghtsnpr** · 04-27-2010, 04:57 PM

I am having problems with this spreadsheet. I am trying to cross compare 3 spreadsheets to find out if an invoice is paid and if the billing matches the invoice. I have attached the file but I can't figure out how to get it to work. Could someone let me know if there is a better way of doing this or if it is possible?

**Leith Ross** · 04-27-2010, 07:25 PM

Hello mdnghtsnpr,

Since the worksheet "Paid" is empty, I am assuming you want to check the worksheets "DCN-log" and "Invoice" against each other to determine if the invoice was paid. If it has been paid then the information from those worksheets would be copied over to "Paid".

What isn't clear is how you are determining when an invoice is paid. Which columns on which sheets are compared to determine the invoice is paid? Please provide a more detailed and clear explanation of what you want to do.

**mdnghtsnpr** · 04-28-2010, 10:54 AM

column "A" on "Invoice" looks at column "A" on "Paid" and if match found it is suppost to highlight the cell yellow.

For b = 2 To DesCount2

If Workbooks(DesFile).Sheets("Invoice").Range("A" & d).Text = Workbooks(DesFile).Sheets("Paid").Range("A" & b).Text Then Call Update_Cell(DesFile, "A", a)

Next b
Next a

**mdnghtsnpr** · 04-28-2010, 12:42 PM

I figured it out. I have to simplify the if statements with else goto's for it to work thanks for the help.

**Leith Ross** · 04-28-2010, 12:46 PM

Hello mdnghtsnpr,

Still working on this. Part of the problem is you are using the ampersand "&" as the logical operator "AND". Not the same the animal. The ampersand is used for concatenation of strings only. You must use "AND" for logical comparisons.

I am adding object variables to the macro. This will help in two ways. One is to eliminate the "spaghetti code" and the second is provide more flexibility.