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,

--
Farhad Hodjat


"Guy Lydig" wrote:

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

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

"Farhad" wrote:

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,

--
Farhad Hodjat


"Guy Lydig" wrote:

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