View Single Post
 
Old 07-20-2016, 02:07 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Code:
Sub blah()
With Sheets("Sub Grade Data")
  For Each cll In Range(.Range("A2"), .Range("A2").End(xlDown))
    With Sheets("Summary")
      For i = cll.Offset(, 2).Value To cll.Offset(, 3).Value - 1 Step 20
        Set colm = .Rows(1).Find(what:=i, LookIn:=xlFormulas, lookat:=xlWhole, searchformat:=False)
        If Not colm Is Nothing Then
          .Cells(22, colm.Column).Value = cll.Offset(, 9).Value
          .Cells(23, colm.Column).Value = cll.Value
        End If
      Next i
    End With
  Next cll
End With
End Sub
Reply With Quote