Macro to Compare two sheets and pull across certain data

  • Hi guys,

    Trying to minimise the amount of manual checking I have to do every day basically I have two sheets:

    Sheet one is from the client and has Columns A-J (D and E being First and last names respectively)

    Sheet one is from our side and has columns A-E ( A and B being First and last names respectively)

    Is there a way for it to look at Sheet 2 column A and B compare these to Sheet 1 Column D and E and then input the data from Sheet 2 Columns C,D and E into columns K,L and M?

    It would be SO SO APPRECIATED :)

Participate now!

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