Worksheets 222222 and cost code (attached)
222222 contains historical data. cost code is current data.
I need to compare the invoice numbers in col A of 222222 with the invoice numbers in col B of cost code.
If the invoice does not exist in cost code then remove row from 222222 else leave it there.
I need to do this over multiple workbooks with different names but 1 at a time. 222222 is simply a sanitised cost code, so the next sheet could be 449281.
I am happy to name each sheet 'report', execute the code and then change it to the proper name (in this instance 222222)
Thanks in advance.