I have an excel sheet in which the data is slightly mixed up. In each operation 4 rows in a column have to be cut and pasted in transposed way in the other sheet. After that it has to copy one more cell (that is 2 cell from the last copied cell) and paste in the same sheet , next to the previously copied. After this it has to return to the previous sheet. Also, for the next cycle of cut paste , it should start pasting in the next row

PLease help.. It is a bit urgent