View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leoc Leoc is offline
external usenet poster
 
Posts: 1
Default How to insert rows based on change in data

I have a coulumn of data that with several rows of the same data and then the
data changes for several other rows and so on down the sheet. I need to be
able to selcet the column and insert a row between where the data changes.
Almost like doing a subtotal but just inserting a blank row to break up the
data.