Find a particular text in column A and copy the value from next column and transpose

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.

Please Login or Register  to view this content.

Kind regards
Leo