Excel macro A friend has a spread sheet he receives every week. He has to copy info from that sheet and past it into a new Excel sheet in a different order and then save the new sheet as a "prn" file. He wants to create a macro (or two) that will do as much of the following as possible. The following cells are always the same. He wants to copy the following cells and then paste each cell area below the previously pasted cell area with one blank cell between each cell area. The "pasted" info is then saved as a "prn" file. Here's the cell info he's coping. D7-F18 D21-F32 H7-J18 H21-J32 L7-N18 L21-N32 I can create a macro but this is out of my league. Questions? Solutions?

Just Record a macro doing everything that he wants. Alternately, record a macro to copy and paste D7-F18. Then another for D21-F32 And so on. Then for the last macro copy all of the other macros into it. Bryan

Hi, I want to convert rows into columns in excel sheet. I tried copy the Data,paste it special. But it doesn't give me the format I want. This is the Data that needs to be Converted: Newrec 1 empno 1 ename a salary 1000 Newrec 2 empno 2 dept IT Newrec 3 desig se dept IT . . . . Newrec 45,000 If I use copy,pasteit special(one time),I Get the format like this: Newrec empno ename salary newrec empno dept 1 1 a 1000 2 2 IT... But the format I want is this: Newrec empno ename salary dept DESIG 1 1 a 1000 na NA 2 2 na na IT NA 3 NA NA NA IT SE ................................... ................................... Can u give me some suggestion? thanks.