Search and copy value based for multiple columns

Hey guys,

I'm looking for a macro to go through every cell in:  Range("E8:E" & (Range("A1048576").End(xlUp).Row))

If it finds a name with a + (plus symbol) then it sends the cell value to an offset of 14 (Column S)

The macro then needs to look in the same range but for Column F and this time if it finds a name with a + (plus symbol) then it sends that cell AND the one to it's left to an offset of 14 (Column T) It then needs to do this for Column G, H, I, J, K L, M & N

I hope this is clear enough, attached is an example which I think is clear enough.

Another option. Click the green arrow in attached.

Please Login or Register  to view this content.