View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ben0209 ben0209 is offline
external usenet poster
 
Posts: 1
Default how do paste same data in every other line

Afternoon all
I am looking at a data table comprising 1 column x multiple rows. I would
like to be able to insert between every entry (all different) the sequence of:
DATA
blank row,
cell containing 'S'
cell containing 'E'
NEXT DATA.

I have seen some threads and can insert three blank rows but am falling down
at getting the specific texts in the cells.
Any help would be appreciated.