Copy paste from one sheet to other in Particilar Cell

[shrinivasmj]

Hi

I have data in Excel like below in excel sheet Need To copy and Paste each ROW
Need to Paste Each ROW in new sheet1,sheet2,sheet3. one by one.

A B C D E
1 Sri 89 H6 YES No
2 Pri 90 K1 No Yes
3 Lio 87 G5 No Yes

Need to copy above data In new file new Sheet need to paste in Particular Cell like below.

A1 Data in C2
B1 Data in D2
C1 Data in E2
D1 Data in F2
E1 Data in C4

 

[venkat1926]

for just copying C2 D2 E2 to first row in second sheet why do you need a macro
you can copy and pastespecial and transpose


what is the logic of choosing C4 after E2


there are only five rows in your data A B C D E
where does the F column comes unless your 1 2 3 etc is also a column(your A B C D in the data is not a row )


please rephrase the question with data.