Go to Tools > Macro > Record New Macro. Now just go through the copies just as uou said. If you have only two or three lines to do, just continue and stop the macro when finished.
If you have many lines, then put the recorded macro inside a loob covering the lines of interest. If the ending line is not always the same, use a dialog box to tell the macro when to stop.
Hope this helps.
Frank
Hi, I hope someone can help me. I would like to copy multiple things in excel and paste them into another sheet. Example, Copy A1 from sheet 1 into sheet 2 and paste to b3 then copy d1 from sheet 1 into sheet 2 and paste it to b5. I then I want to move down to the next row on sheet one and start the process all over but on sheet 2, it would be b7 and then b9. Any way this can be put into a macro?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic