So heres what I need to do. Search a column to see if it contains a string say "ItemA" anywhere in that cell. If it does then copy that row into a new row and add that string to several cells in the new row.

Case "ItemA"
        Copy String to the end of record
        Get column A of row I just copied and add "ItemA" to the begining
Thnx in advance for the help!