To copy the contents of a cell and paste it to another cell if certain condition is true

Hi,
I have a cell which contains a number Off14ch and another cell just above this which contains Off14(Under column named "ID"). Like this i have multiple cells with numbers differing like 14,15,16 etc...I have to search for ch in the column and go to the previous row (which does not have ch) and copy the cell under comment column and append it to the cell under comment column of the row containing the ch.
I guess we have to make use of the fact that the row will be just above this ch.
Please see the attached sheet to understand my question better.
Thanks a lot in advance for help.
I would be greatful

Nida

Is ch always going to be the last 2 characters of the string in column A? If so this should work.

Please Login or Register  to view this content.

Note - This is the easy solution. We could make it much more fool proof but it would take considerable more work

Hey thanks , this works amazing.Ya the string has ch as last two letters. Could you help me in these two points below if this is done then i would be really good
I want two changes in the code.
1. I want the text to be appended before rather then after. ( that is comment text in non-ch row should be appended before the comment text in ch row)
2. After it has appended the comment before the comment text in the ch row . I want to delete the row which is non-ch. ( That is the row above ch)

thanks a lot

Updated

Please Login or Register  to view this content.

Thanks a lot. This helped to reduce a lot of manual work.