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.

You can try it with this:

Please Login or Register  to view this content.

Hoop this helps,

WouterM

Thanks a lot. It works like a charm.

Hi i just change the format and tried to extract the same values i.e. only after the label: , please do find the attached excel and help me out. Thanks in advance.