View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gus gus is offline
external usenet poster
 
Posts: 10
Default How to automatically insert a row if a cell meets a certain criter

I have a large amount of data with irregular patterns, and to perform an
additional amount of analysis, I need to insert a row under every time a
certain field is defined as a certain value (in this case FALSE). Is there
anyway I can do this without coding a full macro..ie with If functions and
Do/loops etc.

Cheers.