Greetings,
I have completed the task by using a VBA macro. After clicking a button "Verify completion" in Invoice Tracking sheet, check marks appear. Operation took 3 seconds on my PC.
Here is what the macro does:
- all visible sheets are checked for occurance of "INV #", invoice numbers are numeric values taken from a column in which "INV #" appears, check mark is taken from 4th column to the right of invoice numbers column
- if invoice number has a check mark, then if such number in Invoice Tracking exists, it receives a check mark
INV # is sometimes in column F, sometimes in column G - that's why I constructed macro like this.
Some numeric values in INV # column are not invoice numbers, but it doesn't hurt, there are max 3 figures, Invoice numbers are 5 figures, besides they aren't going to have a check mark.