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.
Paypal payment has been made to Ozgrid.