title: Find Max Value within a group and copy entire row using VBA
body: <p>I want to find the max value within a group (group by:Column A , max value : column E) and copy entire raw to a next sheet in excel.</p>
  
  <p>A-B-C-D-E</p>
  
  <p>1-10-4-2-5.491</p>
  
  <p>1-10-5-2-5.8</p>
  
  <p>1-20-4-3-4.498</p>
  
  <p>2-30-5-3-6.663</p>
  
  <p>2-30-6-4-8.205</p>
  
  <p>2-10-4-5-8.562</p>
  
  <p>3-10-5-6-7.026</p>
  
  <p>3-30-7-2-10.665</p>
  
  <p>3-30-8-2-8.472</p>
  
  <p>4-10-4-1-4.489</p>
  
  <p>4-10-5-1-5.491</p>
  
  <p>4-25-7-3-0.816</p>
  
  <p>My expectation is to get the output as below in another sheet.</p>
  
  <p>1-10-5-2-5.8</p>
  
  <p>2-10-4-5-8.562</p>
  
  <p>3-30-7-2-10.665</p>
  
  <p>4-10-5-1-5.491</p>
  
  <p>Please suggest a solution.(preferred to have a solution in VBA)Thanks.</p>