I think I might need a macro for this. WS1 is the master sheet. I
need something to find 18 different criteria in WS1colA, if it finds
it, copy only 2 of the rows data (col B and E) to WS2.
If it finds ZA01 in WS1col A, copy to WS2, if it finds ZA02 in 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.

Please advise.

http://www.rondebruin.nl/copy5.htm

gives some basic code that should get you started. You would utilize this
in the Change event of the worksheet
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy



"splat" wrote:

I think I might need a macro for this. WS1 is the master sheet. I
need something to find 18 different criteria in WS1colA, if it finds
it, copy only 2 of the rows data (col B and E) to WS2.
If it finds ZA01 in WS1col A, copy to WS2, if it finds ZA02 in 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.

Please advise.