Copy multiple rows only if column is filled in

[soldevi53]

Hello all,

New here but like the topic explained I would like to use a button on Sheet2"Meter Run", to populate the entire row from sheet 1"Index", only if a certain column filled in, while ignoring other rows until reaching another row with said column populated.

Thanks everyone



I'm pretty bad with excel but I have the button and

Sub copyrows()
     
    'assuming the data is in sheet1
    Sheets("Index").Select
    RowCount = Cells(Cells.Rows.Count, "U").End(xlUp).Row
    For i = 1 To RowCount
         'assuming the true statment is in column a
        Range("a" & i).Select
        check_value = ActiveCell
        If check_value = "True" Or check_value = "true" Then
            ActiveCell.EntireRow.Copy
             'assuming the data is in sheet2
            Sheets("Meter List").Select
            RowCount = Cells(Cells.Rows.Count, "a").End(xlUp).Row
            Range("a" & RowCount + 1).Select
            ActiveSheet.Paste
            Sheets("Index").Select
        End If
    Next
End Sub

Basically if any column pupulated outside the print area(U13-AD13)

it will take that entire row onto the next sheet(meter Run) using the button at the top

[arlu1201]

Please attach a sample workbook and specify what needs to be copied.

[soldevi53]

Here it is

Basically if any column pupulated outside the print area(U13-AD13)

it will take that entire row onto the next sheet(meter Run) using the button at the top

Thanks

[soldevi53]

Anyone? PLease

[soldevi53]

Trying this now but no luck as well

Sub copyrows()
Dim cl As Range
Dim LR As Long
LR = Cells(Rows.Count, "U").End(xlUp).Row
For Each cl In Range("U13:AD" & LR)
If cl = True Then

   cl.EntireRow.Copy Sheets("Index").Range("A" & Sheets("Index").Cells(Rows.Count, "A").End(xlUp).Row + 1)
End If
Next cl
End Sub

[soldevi53]

somebody must have a code I can use or manipulate for this

[soldevi53]

????????????????????????

[arlu1201]

Can you try explaining again? What do you mean outside the print area? Which is the print area u have set? Can you type in some examples into your file so we can understand better?