View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aashish
 
Posts: n/a
Default Entering a row everytime column C changes value

I need help creating a macro that will insert a row everytime a value in
column C does not equal the one before it. My data set can be 1000+ rows, so
doing this manually is a bit mind-numbing. I could also set up may data so
that a 0 or 1 is indicated every row that needs to have a row inserted.

thanks in advance.