Inserting Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel XP

In column A I have a list of over 1,000 names. I want to insert a blank row
after every 10 names. There must be a simple way to do this in VB but I am
not familiar with VB.

If you can help, please be specific.

Thanks

Guy
 
Hi,

Try this by usinghelper colomn:

your data (names) is in column A
helper column=B

enter 1 in first row of column B and 2 in the second row of column B mark
Cells B1 and B2 copy drag down these 2 cells to end of your data in the next
down cell in column B enter 10 and in the next down cell enter 20, marrk 10
and 20 and copy drag down till you reach the number 1000, sort column A and B
based on column B.
it should work.

Thanks,
 
You're a genius. It works like a charm! Thanks!

Farhad said:
Hi,

Try this by usinghelper colomn:

your data (names) is in column A
helper column=B

enter 1 in first row of column B and 2 in the second row of column B mark
Cells B1 and B2 copy drag down these 2 cells to end of your data in the next
down cell in column B enter 10 and in the next down cell enter 20, marrk 10
and 20 and copy drag down till you reach the number 1000, sort column A and B
based on column B.
it should work.

Thanks,
Click to expand...
 
Back
Top