View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
peabody peabody is offline
external usenet poster
 
Posts: 2
Default insert row using conditional formatting

I have a fairly large worksheet with a number of stores listed and their
sales for the year. Some stores have entries for 10 years, some have only
one. I would like to insert a blank row between the different stores,
keeping the same store info together. Is there any way to do this with
conditional formatting or a macro? Doing it manually would take way too much
time.