Ok here goes - hopefully I explain it OK and someone can help - if you can this will save me hours and hours of work a week.
Each week I pull off a list of invoices for my team to chase. This list goes into excel and they put notes in the last column detailing what they have done. i.e.
invoice No, Description, Value, Comments
The trouble is each week I pull a new list and some invoices have been paid etc thus we need to use the new updated list. The bad side is I lose all notes as the notes are not from the system.
so heres my question. Is there any way to write a macro or something that will do the following things,
(((((List A = Old list that has notes on
List B = New list with invoices paid cleared from it and new invoices on))))
1. It will need to compare both lists. The macro needs to look at List A, if the invoice number in cell A1 is on the list B then move to the next cell i.e. A2. If the invoice number in cell A1 is not on the new list B then delete the row and move to cell A2
2. Another Macro to work the opposite way. Any invoices on List B that are not on List A need to be highlighted.
Im really hoping someone can help with this one.
Thanks all.
Each week I pull off a list of invoices for my team to chase. This list goes into excel and they put notes in the last column detailing what they have done. i.e.
invoice No, Description, Value, Comments
The trouble is each week I pull a new list and some invoices have been paid etc thus we need to use the new updated list. The bad side is I lose all notes as the notes are not from the system.
so heres my question. Is there any way to write a macro or something that will do the following things,
(((((List A = Old list that has notes on
List B = New list with invoices paid cleared from it and new invoices on))))
1. It will need to compare both lists. The macro needs to look at List A, if the invoice number in cell A1 is on the list B then move to the next cell i.e. A2. If the invoice number in cell A1 is not on the new list B then delete the row and move to cell A2
2. Another Macro to work the opposite way. Any invoices on List B that are not on List A need to be highlighted.
Im really hoping someone can help with this one.
Thanks all.