Replace row number 12 to row number 22

[abhi_dube1]

Hello,
I am working on data sheet where i have to replace some cell to another cell. every time i am coying data the paste some where else then inserting data. it is being a long process.
do we have any formula where we can replace entire row for example
row 22 to rplace with row 12.

Thanks

 

[Tom Urtis]

Can you not select the row 22 header (which selects all or row 22), right-click it and select Copy, then select the row 12 header, right click on it and do a paste or paste special for values.

Maybe there is more to what you are wanting to do, if so please explain.

 

[abhi_dube1]

Thanks tom,

I want to replace the data in row 22 to row 12. means all data of row 22 should go to row 12 and alll data of row 12 should transfer to row 22

thanks