[abstraxtion]

Hello,

wondering if anyone can help me out. my mom works as a secretary. Her new boss gave her 28 existing spreadsheats in excel 97, all of which have 250-400 rows of info. He wants her to insert a row after each existing row. Is there a quick way to do this? I have tried everything I can think of but i dont know excel very well and so far nothing works. I tried to create a macro, but the macro keeps inserting rows only after the first selected row. any ideas greatly appreciated,

dino

[Advertisements]

Dino,
You have at least 2 options.

1. You could write some VB code to do this, but there is an easier method.

2. Easy Method
-Inset a new column before column A
-In the new column type in a sequential number for each cell from 1 to 400 (assuming there a 400 records)
(you can use autofill to do this)
-Copy the numbered cells and paste them in column A below the last value
-Highlight entire sheet and then sort by column A then B
-Column A should now look like;
1
1
2
2
3
3
4
4
...
...
400
400

-Every second line should be blank except for the number in column A
-Delete column A


HTH
David

[dsm]

Dino,
You have at least 2 options.

1. You could write some VB code to do this, but there is an easier method.

2. Easy Method
-Inset a new column before column A
-In the new column type in a sequential number for each cell from 1 to 400 (assuming there a 400 records)
(you can use autofill to do this)
-Copy the numbered cells and paste them in column A below the last value
-Highlight entire sheet and then sort by column A then B
-Column A should now look like;
1
1
2
2
3
3
4
4
...
...
400
400

-Every second line should be blank except for the number in column A
-Delete column A


HTH
David