| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populating Rows
Figured this out - thanks
"teresa" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating rows from a worksheet to a second worksheet | Excel Discussion (Misc queries) | |||
| Populating Rows Below | Links and Linking in Excel | |||
| vba function ( populating rows) | Excel Discussion (Misc queries) | |||
| Populating another tab. | Excel Discussion (Misc queries) | |||
| adding rows and populating them with data from other columns | Excel Programming | |||
Hybrid Mode
