All questions this time...

How are you determining what original data row to copy?
Where do you put it on sheet2?
How do you manipulate the data? Manually or existing macro?
How do you insert the manipulated data back into sheet1?
Why are you doing all this?

Have you used the macro recorder to get an idea of how this would go in a macro?