Hi, similar problem to deadpandad..... WS1 is the master sheet. I
need a formula to find 18 different criteria in WS1colA, if it finds
it, copy only 2 of the columns data (col B and E) to WS2.
If it finds ZA01 in WS1col A, copy to WS2, if it finds ZA02in WS1col
A, copy to WS3 etc.

If I add data to WS1, and the col A has the matching criteria, it will
need to update the corresponding worksheets automatically.