The attached has your macro re-written.
If the code in column A is not found on the other sheets nothing changes.
If it is found then cells are updated, including putting "???" in cells where values don't match any of your combinations (there were none in your sample file).
Note that column C is not updated at all as is the case with several other columns - be careful.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
