View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default Script to insert Row

How would I write a scrtip to insert a row under the number in A that holds a
"NS" or "MT"? I would also like it to copy the row that has "NS" or "MT" in
it and paste it in the row that was inserted underneith. When it copies the
row it will copy the whole row except what is in A.

Example Before
A B
1 MT 12
2 D 14
3 x 15


Example After
1 2
1 MT 12
2 12
3 D 14
4 X 15


Thanks