Compare the columns in two excel workbooks

    OK ...


    So attached is your revised test file ...


    Make sure to Adjust with your local path in the Import macro ... so that your ' Employees BS ' file can be opened and data copied


    Hope this will help :)

    Happy to hear this could help you out ... :)


    By the way, while you will testing it out, ask yourself if you could be running into a situation ( may be after a couple of imports ...) where you would need to remove all potential Duplicates in your Employees Names Data column ...

    It could be easily added to your macro ...


    Take Care

    Cheers

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

    Just in case ...

    To delete potential Duplicates ;)

    Code
    'To Delete potential Duplicates in Sheet2
'lastr1 = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row
'Sheet2.Range("A1:A" & lastr1).RemoveDuplicates Columns:=1, Header:=xlYes

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

    Hello Carim,


    Hope you are doing well,


    Yesterday, I had an opportunity to test it out,

    Everything went well, Thank you for that :)


    I was thinking if it could be possible to add this feature,


    To import the sheet from another workbook

    1) I click the Import button

    2) it opens the folder to select any file from there, regardless of file names, For example, If I have a file named BS1 instead of BS, I should be able to select that file and import the data


    Is there any possibility to do that? :)


    Thank you so much in Advance


    Regards

    Julia

    Glad to hear your real-life tests did produce the expected results :)


    Regarding your latest request, it is indeed feasible ... as soon as I have a moment, will get back to you ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    Quote from Julia kumr

    Thank youuuuuu soooo much, You are just awesome <3

    I did not quite catch your last remark ... Can you repeat it louder ... ??? ;) ;) ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login