View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
camsd camsd is offline
external usenet poster
 
Posts: 1
Default Insert 5 rows between existing values in a single column 1

I have a sheet with over 10,000 rows of existing data, all in a single column.

I need to insert 5 rows in between each existing row quickly and easily.
Doing it manually is not so efficient!

For example:

F14745
F14746
F14747

needs to become:

F14745




F14746




F14747



etc.,

Likey a way to do this with a Macro, but I don't have a clue on how to do it.
Easy way seems to elude me.

Thanks.