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...
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...