View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emajination Emajination is offline
external usenet poster
 
Posts: 2
Default If value is equal, if not a blank row is inserted.

I need to have a formula that checks each row in a spreadsheet and
compares the values in columns B, D, E. If the values in the all three
columns are the same, no action is required. If the value in all three
columns changes, a blank row should be inserted between the lines that
differ. So it sounds like i need a formula to do the comparison that
will call in a macro to do the row insertion when it applies.

Thank you in advance