1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Combining Data, Excel .xlsx

Discussion in 'Hire a Freelancer' started by webscraper, Oct 28, 2013.

  1. webscraper

    webscraper Newbie

    Joined:
    Jun 24, 2013
    Messages:
    18
    Likes Received:
    3
    I want to be able to have something that does this on my own through Excel Macros or something. Here is what I need

    I have 2 excel sheets..

    Sheet 1 has Company Name, Address, Phone,Url, Email (email column is blank)
    Sheet 2 has Url, and Email

    I need to be able to combine the 2 lists filling in the emails in the right column with the url name being the deciding factor.

    I hope this makes since!

    Skype Me: trackmafia
     
  2. mthree

    mthree Newbie

    Joined:
    Nov 29, 2011
    Messages:
    8
    Likes Received:
    3
    Sort both sheet one and sheet 2 by url descending or ascending but the same on both sheets

    then copy and paste the emails column from sheet 2 to sheet 1

    I am presuming you have the same number of entries in each sheet
     
    • Thanks Thanks x 2
  3. webscraper

    webscraper Newbie

    Joined:
    Jun 24, 2013
    Messages:
    18
    Likes Received:
    3
    The problem. Is there is not an email for some of the rows. So this wouldn't work :/
     
  4. ContentWriter

    ContentWriter Jr. VIP Jr. VIP

    Joined:
    May 8, 2013
    Messages:
    1,804
    Likes Received:
    211
    Occupation:
    Content Writer
    Home Page:
    I added you on Skype. Let's chat ASAP so I can deliver this ASAP, too.
     
  5. mthree

    mthree Newbie

    Joined:
    Nov 29, 2011
    Messages:
    8
    Likes Received:
    3
    do you have the same amount of URLs in both sheets ?
     
  6. ardley216

    ardley216 Elite Member

    Joined:
    Mar 28, 2008
    Messages:
    2,391
    Likes Received:
    2,356
    Occupation:
    Finding easy keywords
    Location:
    1,500,000,000 Keywords Re
    Home Page:
    ITs very easy to do it with CSV files.

    Use CMD, and use:

    Code:
    copy *.csv name.csv
    Then open it back up in excel.

    I did this to combine csv files with millions of lines.
     
  7. mthree

    mthree Newbie

    Joined:
    Nov 29, 2011
    Messages:
    8
    Likes Received:
    3
    that would only combine 2 or more csv files into 1 csv file.

    He has only 1 csv file but 2 tabs inside the file
     
  8. jp_smith86

    jp_smith86 Senior Member

    Joined:
    Jul 6, 2012
    Messages:
    855
    Likes Received:
    340
    Location:
    DIL APNA PUNJABI
    Home Page:
    Too easy. use vlookup function buddy. I can do this free of cost. add me on skype.
     
    • Thanks Thanks x 1
  9. mthree

    mthree Newbie

    Joined:
    Nov 29, 2011
    Messages:
    8
    Likes Received:
    3
    True very easy .
     
  10. webscraper

    webscraper Newbie

    Joined:
    Jun 24, 2013
    Messages:
    18
    Likes Received:
    3
    jp_smith86 made this happen for me !!! Thanks guys
     
    • Thanks Thanks x 1
  11. kung fu panda

    kung fu panda BANNED BANNED

    Joined:
    Oct 10, 2013
    Messages:
    416
    Likes Received:
    103
    added on skype.
     
  12. gokulvikas

    gokulvikas Junior Member

    Joined:
    Nov 16, 2010
    Messages:
    120
    Likes Received:
    15
    It's very easy. Just use vlookup function in excel. Or add me at skype gokulvikas1986
     
  13. blackhat777

    blackhat777 Elite Member

    Joined:
    Jun 25, 2011
    Messages:
    1,779
    Likes Received:
    653
    A simple vlookup will do it for you. Send me the details. I can do this.
     
  14. pishty

    pishty Junior Member

    Joined:
    Dec 17, 2012
    Messages:
    132
    Likes Received:
    26
    Location:
    Bucharest
    True, just one simple vlookup formula and you're done.