Help with a comparing query

Hi Adam

Thanks for your question


Can you clarify my understanding

You are downloading data and you wish to compare the values contained in a column called Seedol, with a similar column in the master list. If you find rows in the downloaded data that have values not contained in the master list, then you wish to add that data to the master list.

Is this correct?

Thanks

Stephen

Hi Adam

Thanks for the clarification

I have written some code that does what you need

It simply goes through the downloaded data line by line and for each line goes through the master list line by line and checks to see if there is a match. If it gets through the whokle list without finding a match it writes the data to the next blank line in the master list

In enclose the code below, and have attached a workbook as an example

Sub ListChecker()



    Dim i As Integer

    Dim j As Integer

    Dim blnItemFound As Boolean

    Dim k As Integer

    

    For i = 2 To Range("H1").CurrentRegion.Rows.Count

    

        blnItemFound = False

        

        For j = 1 To Range("A1").CurrentRegion.Rows.Count

        

            If Range("H2").Cells(i, 1) = Range("A1").Cells(j, 1) Then

                blnItemFound = True

                Exit For

            End If

    

        Next j

    

        If blnItemFound = False Then

        

            k = Range("A1").CurrentRegion.Rows.Count + 1

            

            Range("A1").Cells(k, 1) = Range("h2").Cells(i, 1)

            Range("A1").Cells(k, 2) = Range("h2").Cells(i, 2)

            Range("A1").Cells(k, 3) = Range("h2").Cells(i, 3)

            

        End If

    

    Next i

    

End Sub