View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JHopper JHopper is offline
external usenet poster
 
Posts: 5
Default Scan for combo then insert row

I have a worksheet sorted by Columns D, E, and G. I am trying to create a
macro that, starting in row 3, will scan every row in Columns D, E, and G for
the following combination

Column D = Sale
Column E = Purchaser
Column G = Solution

When I find the last record of this combination (Column D/Sale), (Column
E/Purchaser), (Column G/Solution) I would like to insert a row below the last
combination. Can you help me?