How do I select every 5th row within a list?

[Guest]

I am making a spreadsheet of all of our products and all of the options
(colors, mounting, options, etc) my sheet already contains about 15,000 rows,
and i need to A) create 5 blank rows below EVERY row B) for every row i put 5
rows under, i need to copy and paste into those 5 rows C) change a certain
piece of a part number to multiple diffent things, (ie: slx60sr10wh,
slx60sr12wh, slx60sg10wh, slx60sg12wh, etc) but with multiple options for
every small option. So now, of my 15,000 rows, i'm about to add 8 rows to
every one, so that makes 120,000 part numbers i have to change! i want to be
able to tell excel to select every 5th row in the list so i can then go to
find/replace and just replace 15,000 at once, and not do them all
individually by hand. Somebody please help me out, i'm about to lose my mind.

 

[DOR]

You may have to reconsider what you are trying to do, or how you are
trying to do it, because Excel can have no more than 65,536 rows per
sheet!

Are you sure you want to manipulate that many rows with Excel?

If you could describe what you are trying to achieve with these
inserted rows someone may have a creative solution.

Declan O'R

 

[PY & Associates]

To overcome 65,536 rows limit,
cut rows 10,000 to end, paste in sheet3
cut rows 5,001 to end, paste in sheet2

then in each sheet (you only have 3)
for i=5000 to 2 step -1
for j=1 to 5
rows(i).insert
next j
next i

You now have the additional rows you want.

This is your job?
C) change a certain piece of a part number to multiple diffent things, (ie:
slx60sr10wh,
slx60sr12wh, slx60sg10wh, slx60sg12wh, etc) but with multiple options for
every small option

[i'm about to add 8 rows to every one]
You mean the original row1 becomes row1 to row6, and now becomes row1 to
row14?
then [every 5th row ] is now not correct.

Now you have more than 1 sheet, you need to loop instead of selecting 15,000
cells then.