Hello All,

I need a macro to find a particular text in column A ("Label:") and copy the value from next column B which is highlighted in red color into a new sheet and also transpose the values from columns A after ("Modif Desc") to into the new sheet as Rows. I have attached the sample excel file. Kindly do have a look over it.

Thanks in advance.