Hi All
I'm hoping someone may be doing something like i need to do already, or at least point me in the right direction.
I have two worksheets in the same workbook. One is "Invoice List" this contains all the invoice numbers and values, column B (has a header) and has all the invoice numbers I'm trying to match. The second sheet "Remittance Import" has the invoice numbers in column C (has a header)
What I want to do is compare the invoice numbers in the remittance against the invoice list, if there is a match then put "Yes" in column F of the matching row of the Invoice list. (This way I know if the invoice has been paid)
If it was just one remittance I would do it with a formula, but i have 200+ remittances to check and the Invoice List sheet contains 20k plus rows. I have set it up so a remittance can only be checked once to save any confusion.
What I will do when the comparison for each remittance is completed is clear the Remittance Import sheet ready for the next entry.
Any help would be really appreciated.
cheers
Paul
I'm hoping someone may be doing something like i need to do already, or at least point me in the right direction.
I have two worksheets in the same workbook. One is "Invoice List" this contains all the invoice numbers and values, column B (has a header) and has all the invoice numbers I'm trying to match. The second sheet "Remittance Import" has the invoice numbers in column C (has a header)
What I want to do is compare the invoice numbers in the remittance against the invoice list, if there is a match then put "Yes" in column F of the matching row of the Invoice list. (This way I know if the invoice has been paid)
If it was just one remittance I would do it with a formula, but i have 200+ remittances to check and the Invoice List sheet contains 20k plus rows. I have set it up so a remittance can only be checked once to save any confusion.
What I will do when the comparison for each remittance is completed is clear the Remittance Import sheet ready for the next entry.
Any help would be really appreciated.
cheers
Paul