VBA code for compare two columns in excel, and copy the difference at the bottom of column 2

[lilloscar]

This code do exactly what I need but I can't figure it out how to adapt it to my needs...
Please can you tell me how can I change this to work instead searching from A1:C and coping missing data to D1:F to work only comparing two columns J1:J and K1:K

Attach: https://www.4shared.com/s/fI0i45Uxyda

Option Explicit

Sub test()
    Dim a, i As Long, ii As Long, x As Range
    With Range("a1").CurrentRegion
        a = .Value: ReDim b(1 To UBound(a, 1) * 2, 1 To 3)
        With CreateObject("Scripting.Dictionary")
            .CompareMode = 1
            For i = 1 To UBound(a, 1)
                If a(i, 4) <> "" Then .Item(a(i, 4)) = Empty
            Next
            For i = 1 To UBound(a, 1)
                If Not .exists(a(i, 1)) Then
                    If x Is Nothing Then
                        Set x = Cells(i, 1).Resize(, 3)
                    Else
                        Set x = Union(x, Cells(i, 1).Resize(, 3))
                    End If
                End If
            Next
        End With
        If Not x Is Nothing Then
            x.Copy Cells(Rows.Count, 4).End(xlUp)(2)
            Set x = Nothing
        Else
            MsgBox "No new item"
        End If
    End With
End Sub

 

[JackDanIce]

Can you explain your problem precisely as your PC screen is not visible?

This code searches column D for blank cells and pastes A:C of the same row under the last row of column D. It seems to be doing something similar to filtering column D for blank cells and copying the visible cells from A:C and putting at bottom of column D.

What do you have in J1:J and K1:K and what is the expected outcom?

 

[lilloscar]

For example, am not interested in the red columns, just want to know how to compare two columns (yellow), the first column A varies his data, and second column D register all the history and changes in A making a list, but I can't resolve how to move that columns (A and D) to other columns, for example J an K.

 

[JackDanIce]

Your screen is not visible, do you understand what that means?

Red column where? What is in columns J and K? Your spreadsheet is in front of you and nobody else.

Use an example to explain what you need the code to do. In your example use exact cell addresses, sheet names, etc.

 

[lilloscar]

1- Your screen is not visible, do you understand what that means?

2- Red column where? What is in columns J and K? Your spreadsheet is in front of you and nobody else.

3- Use an example to explain what you need the code to do. In your example use exact cell addresses, sheet names, etc.

1- I don't know what you mean by screen not visible.

2- Red column in my attached image, and what is in J and K doesn't matter is the same data as the A and D (image), I attached in my first post the .xlsm file if you want to see it, so it is not only in front of me.

3- My example is in the image attached and my explanation.

I think you are annoyed of me, I have to repeat a common foreign phrase: "sorry for my bad English".

 

[Fluff]

@lilloscar
Some members cannot follow links due to security systems at work. Others wont follow links for safety reasons.
I looked at the link & there are a number of buttons marked "Download". Because of this very very few members will download your file, as they have no idea which is the correct button & which will download a load of adware/spyware/whatever.

 

[lilloscar]

@lilloscar
Some members cannot follow links due to security systems at work. Others wont follow links for safety reasons.
I looked at the link & there are a number of buttons marked "Download". Because of this very very few members will download your file, as they have no idea which is the correct button & which will download a load of adware/spyware/whatever.

Thanks! Is any server that you recommend me to upload my .xlsm file?

 

[Fluff]

Remember what I said here https://www.mrexcel.com/forum/excel...ted-area-remove-white-spaces.html#post5149852 about cross posting?

 

[lilloscar]

Here I uploaded to Dropbox
https://www.dropbox.com/s/bijusc3d2y7xq3h/Compare columns and copy missed data.xlsm?dl=0

@JackDanIce

I think is a great code, but I am not a programmer to know what I have to modify to use this on other columns like J and K, suppressing B, C, E and F results, I only need the A and D results in different columns.

I don't have any degree on this, I am a Civil Engeneer just trying to get things easier on my work, always I do a lot of taste, research and google, but this code is hard for me.

 

[Fluff]

Please supply the cross post links.