+ Reply to Thread
Results 1 to 12 of 12

Finding identitcal entries in two sheets and copying missing data

  1. #1
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Finding identitcal entries in two sheets and copying missing data

    I am so stuck guys.

    I have two lists.

    List number 1: Two columns, each column has random numbers and letters, but each entry of the column is paired up with other column.

    Example list number 1:
    Column 1 Column 2
    291238 asdasda
    2312 578ddassa

    List number 2: Five columns, the absolute same thing, except one of the columns is EMPTY and in one of the five columns are SOME same records from column 1 in list one.

    I am supposed to write a macro that would find what identical entries are in column in sheet 2 and sheet 1 and then copy the other paired entry from list number one to empty list number two.

    Example list number 2:
    Column 1 Column 2 Column 3 Column 4 Column 5
    8795465 empty asdkj 897989 asdjooads
    2312 empty 458945 sadds 4654564654

    I need to get "578ddassa" from list 1 column 2 to list 2 column 2. The thing is that in list number two column one are SOME identical numbers that are also in list numeber one, some are not. So this macro needs to find which numbers are same in column 1 in both lists, then copy the paired entry from column 2 list number 1 to list 2 column 2 of the identical entry of list 2 column 1.

    Oh. My. God.
    Last edited by jk2017j; 06-30-2019 at 06:20 AM.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Hells bells macro - help me

    If you attach a workbook with some sample data and the expected results it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Hells bells macro - help me

    Okay I will just gimme a sec

  4. #4
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Hells bells macro - help me

    I hope you understand me now. I underlined the data which should be the same.
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: Hells bells macro - help me

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

    I would do this for you, but I cannot work out what you are trying to do, so you will have to do it yourself - sorry,
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Hells bells macro - help me

    AliGW: The things is that I also don't know how to do it, I just know how it should look in the end. Is this some kind of sort and copy macro? I'm not sure.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: Hells bells macro - help me

    You don't need to know HOW to do it. Read my instructions again: you are being asked in your title to explain WHAT you are trying to achieve. If you Googled "Hells Bells Macro - Help Me", do you think you'd find anything relevant? Please change your title as requested. Thanks.

  8. #8
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Help me find a macro for this please

    AliGW: Sorry, but I really don't know how to name this.

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Help me find a macro for this please

    Try the sentence in your first post starting with 'I am supposed to..." starting from the word "find".
    It explains it all

  10. #10
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Help me find a macro for this please

    Pepe Le Mokko: Thanks very much, I think that names it well. I'm still kind of lost though. Any hints would be appretiated. Do I divide the macro into more parts? This looks way too difficult for me.

  11. #11
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Finding identitcal entries in two sheets and copying missing data

    Thank You for changing the title.
    1. Is this an assignment for a class?
    2. Does this have to be done using a macro/VBA or would a formula solution be acceptable?
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  12. #12
    Registered User
    Join Date
    06-30-2019
    Location
    Czech Republic
    MS-Off Ver
    Google Excell
    Posts
    7

    Re: Finding identitcal entries in two sheets and copying missing data

    I found the solution myself.

    I swapped the columns on sheet 1 and then used vertical lookup from sheet 2 to sheet 1.

    It is amazingly sad that some of the local moderators are so strict about naming the topic correctly, but not helping with finding the solution or the correct naming. For the sake of finding the solution and naming the topic correctly so that other users can search and find solutions to their similar problems, you should be deleting your own comments about how a topic doesn't meet the required standards after they've been fixed. Otherwise there is just no point.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] macro showing error ( macro not found ) while trying to execute macro every 1 minute
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2018, 07:58 PM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  4. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  5. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  6. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1