Thread: Populating Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Populating Rows

I have 3 Vodafone's,
so below in the Vodafone Worksheets I should have
Rows 14,15,16 with entries.
However not quite getting there,thanks for any help

For i = 3 To lastrow
j = 14

If Cells(i, 4) = "Vodafone" Then
Cells(i, 5).Copy Destination:=fin.Worksheets("VODAFONE").Cells(j, 2)
Cells(i, 6).Copy Destination:=fin.Worksheets("VODAFONE").Cells(j, 9)
End If
Next

j = j + 1