View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeT[_2_] MikeT[_2_] is offline
external usenet poster
 
Posts: 3
Default Inserting rows based on another cells value

I have a column of cells that could have the value of
either 1, 2 or 3.

I want 1 row added below the cell if the value is 2, 2
rows added below the cell if the value is 3 and no cells
added if the value is 1.

Anyone know if this is possible and if it is how is it
done.