Excel Macro to copy and transpose base on cell value

[debbers]

Hi all,

I am struggling to create a macro which allows me to copy and transpose base on cell value. I have a table as below and I want to use copy and transpose base on those cell values.

For example, task 1 is to copy and transpose cells A3:C3 to a new sheet, task 2 is to copy and transpose cells B3:D3 to a new sheet, and so on...

 

[ZMyrrh]

Please share the workbook if you can. Or at least share the worksheet in which you are using please.