![]() |
|
|
|
#1
|
|||
|
|||
|
Here are two attempts that failed :
Code:
Sub Names()
Dim Cell As Range
Dim NextRow As Variant
Dim lrA As Long ', lrD As Long
Dim i As Long, j As Long, x As Long
Application.ScreenUpdating = False
lrA = Range("K" & Rows.Count).End(xlUp).Row
NextRow = Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1
For i = 7 To lrA
If Range("K" & i).Resize("N" & i).Value = "0.00" Then
Range("K" & i).EntireRow.Copy Destination:=NextRow
End If
i = i + 1
Next i
Application.ScreenUpdating = True
'MsgBox "completed"
End Sub
Sub copy_rows()
Dim i As Long
i = Sheet1.Range("A" & Rows.Count).End(xlUp).Row
For i = 7 To i
If Cells(i, 11) = "0.00" And Cells(i, 12) = "0.00" And Cells(i, 13) = "0.00" And Cells(i, 14) = "0.00" Then
Cells(i, 11).EntireRow.Copy Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1
End If
Next i
End Sub
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA Code to copy data from two sheet ,paste into corresponding sheet through cmdbutton | jackfruit88 | Excel Programming | 1 | 07-08-2022 09:27 PM |
| copy paste of pst sees address book empty , why ? | DBenz | Outlook | 1 | 05-30-2019 10:21 PM |
| copy a row and paste the row into another sheet more then one time:macro | waqar1239 | Excel Programming | 1 | 04-07-2017 09:57 AM |
How to copy excel sheet withe HEADER and Paste into new sheet?
|
cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
| copy checkbox string and paste it in excel sheet | MOHAMMEDSALMAN | Excel Programming | 7 | 10-29-2015 03:50 AM |