Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Find and move rows

I need help with a macro that can check sheet 1 which has content as this

Column A has this

Sheet 2 has many columns of data and many rows

Need to search full content and move the complete row if found as column A of sheet 1 to sheet 3

Whole row should be copied or cut either ways is fine with me
Avatar of hanklm

FYI:  The image links don't seem work - at least not for me.

I get redirected here:

Maybe it's just a temporary issue?
Avatar of Saqib Husain
It would be better if you upload the files on experts-exchange.

Better still if you can upload an excel file (possibly fictitious) so that direct testing could be done instead of rebuilding the data.
Avatar of bsharath


The links are dummy that i placed

These URl's 100's will be in sheet1 column A

Find each in sheet 2 and copy full row to sheet 3
Any help with this please?
Please throw in a sample file to work on.
Please find attached sample file
Here you go

Sub getfoundurls()
    Dim cel As Range, fs2 As Range
    For Each cel In Sheet1.UsedRange.Columns(1).Cells
        Set fs2 = Sheet2.UsedRange.Find(cel, , , xlWhole)
        If Not fs2 Is Nothing Then
            fs2.EntireRow.Copy Sheet3.Cells.SpecialCells(xlCellTypeLastCell).Offset(1).EntireRow
        End If
    Next cel
End Sub

Anyway i can color sheet 1 cells whose content is not found in sheet 2 and was skipped
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you