View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Insert Row every 13th row, then Concatenate

Hello,

Have a list in column A. Every 13th row, I'd like to add a row. Then in
that new row, I'd like to Concatenate the text in the first row with the text
in the 12th row (in cell A13). From there, it would step down another 13
rows, insert a row, and in that new cell concantenate the text from row 14
with that found in row 25.... and so on.

Help?! TIA