Hi, not sure how clearly I can explain this but please look at the worksheet attached for a clearer explanation.

I have 9 Columns (C,D,E,F,G,H,I,J,K) with text in it. The number of rows varies so the code must look for the last non-empty row in column C.

I am looking for a code to look for a particular value in range D6:H? (e.g. "Name Whatever" located in a "Target" cell in the same worksheet).

If a cell in range D6:H? contains the target, the cell must be deleted and the cells must be shifted to the left but only over the range D:H.

For instance, suppose cell E10 contains the target, then the content of cell E10 would be replaced by that of cell F10, the content of cell F10 would be replaced by the content of cell G10, the content of cell G10 would be replaced by the content of cell H10 and the cell H10 would be blank. Importantly, the cells in C10 and I10:K10 would not be modified.

This means that if a match is found in cell H?, it simply gets replaced by an empty cell (no cell to the left to shift).

As I said, this is easier to understand by taking a look at the attached worksheet.

Many thanks for the help!

Example2.xls