I want to copy cells that have specific words

 Trowa -
I am working on a workbook that logs defects for many different ships, which are catagorised as OPEN or CLOSED and have a description of the problem in the adjacent cells.
I am interested in extracting only the OPEN defects and the description of them.

The sheet runs from C:MD and each ship takes about 16 columns each. For the first ship is the OPEN/CLOSED column, G is a HIGH MEDIUM or LOW designator and H:R are merged to allow the description of the problem.

this is repeated for the next vessel beginning at T and follows across all the way.

Pease can someone help me?


1 reply


I would advise you to rearrange your data so you can use autofilter.

Best regards,