Transfer data in column to rows in excel or macro

[zabihsial]

I have data of of over 2000 workers on Sheet1.
I want to transfered filtered Data to Sheet2.
Data of Sheet1 from A2 to D2 should transfer as it is.
Remaining data in Column E2:E13 on Sheet1 should transfer to Sheet2 to G1:R1
And data in Column F2:F13 on Sheet1 should transfer to Sheet2 to G2:R2

 

[Ammi1989]

Re: How to transfer data in column to rows in excel or macro??? Plz help

you can copy and paste data. Below is sample code.

sub test()


sheets("Sheet1").range("A1").copy
sheets("Sheet1").range("D1").pastespecial xlpastevalues, transpose

sheets("Sheet1").range("E2:E13").Copy
sheets("Sheet2").range("G1").pastespecial xlpastevalues, transpose

sheets("Sheet1").range("F2:F13").Copy
sheets("Sheet2").range("G2").pastespecial xlpastevalues, transpose
end sub