Inserting dupicate rows
 

I have a 3000 lrow xlss.

First ,I need to insert an identical row below each current row so the xlss
would have 6000 lines with the 2 identical rows grouped together.

Then on the newly created identical row, I need to make changes to the data
in a couple of cells. The changes would be the same for all rows. Is there a
formula to make identical changes to every odd or even row? Or every other
row?

Inserting dupicate rows
 

Maybe something like this:

With
A1:Z6001 containing your current list,
with Row_1 containing column headings

Then
Insert a new column at Col_A
Put sequential numbers from 1 to 6000 down from A2 through A6001
Copy from A2:Z6001
Paste below the data
(now you have a duplicate recordset below the original data)

Make the changes to the duplicate set

Sort the orignal AND duplicate set based on Col_A
(All the 1's will group together, the 2's etc)

Is that something you can work with?
**********
Regards,
Ron

XL2002, WinXP


"leo" wrote:

I have a 3000 lrow xlss.

First ,I need to insert an identical row below each current row so the xlss
would have 6000 lines with the 2 identical rows grouped together.

Then on the newly created identical row, I need to make changes to the data
in a couple of cells. The changes would be the same for all rows. Is there a
formula to make identical changes to every odd or even row? Or every other
row?