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.