+ Reply to Thread
Results 1 to 12 of 12

Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

  1. #1
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Cool Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    Hi, I'm brand new to Excel.

    I have two worksheets that I would like to merge.

    The first sheet has about 200 hundred names and addresses.

    The second sheet has about fifty names, each having a reference number next to them.

    The fifty names are all included within the 200 names.

    I'd like to send the addresses from the first sheet to the second sheet so that I have a spread sheet that shows Name/ Address/ Reference Number.

    thanks for any help

    Last edited by headwax; 12-11-2017 at 02:43 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Merge Two Worksheets Data while Filtering Help Please :)

    Hi. Welcome to the forum.

    To help us help you, it's always a good idea to attach a sample of your workbooks so we can look for a solution without having to re-create your data first. There is a link in my signature below that will take you to some instructions for uploading attachments. Be sure to replace any sensitive data such as names in a copy of your workbook before attaching the copy as a sample.

    Good luck.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Merge Two Worksheets Data while Filtering Help Please :)

    Thank you for the quick reply @tuph

    and for the howto link!

    please find attached a simple example

    I've put both sheets in one workbook - I'd like to take the addresses from sheet 2 and put them with the right names on sheet 1



    thanks again
    Attached Files Attached Files

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,717

    Cool Re: Merge Two Worksheets Data while Filtering Help Please :)

    With PowerQuery (free add-in for Ex2013 from MS site)
    see sheet3 - is that what you want?
    Attached Files Attached Files
    sandy
    [SIZE=1]How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Merge Two Worksheets Data while Filtering Help Please :)

    thank you @sandy666

    that's terrific thank you

    thanks for taking the time to help me too

    cheers from Oz (I bet I'm back with a zillion questions!)

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,717

    Re: Merge Two Worksheets Data while Filtering Help Please :)

    million will be enough

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

  7. #7
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Merge Two Worksheets Data while Filtering Help Please :)

    thanks for that finally sorted ! like a dog worrying the bone

    okay only a million cheers !



    https://support.office.com/en-us/art...2-7ca2616d17f9
    Last edited by headwax; 12-11-2017 at 02:34 AM.

  8. #8
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    Gah , it worked fine with my simple data base - but now when I go to the real one I get a series of Nulls in the address column

    steps I run a query using merge - I get the persons name and reference number

    (But it says this has matched 0 out of the 113 rows?)

    EDit I see the names in one sheet are in capitals eg MR SMITH , on the other they are 'Mr Smith'

    I then add a another column and choose addresses from the second Excel file - and end up with null

    I am taking the names addresses reference numbers out of another data base that exports excel files

    any more clues welcome
    Last edited by headwax; 12-11-2017 at 02:58 AM.

  9. #9
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,717

    Re: Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    try this way:
    first table must be shorter then second (in other words - first table has more (full) data then second)

    if there is no any addresses how Excel know what should be there?

    maybe add more (dummy) data with reflected structure - and attach this file again
    and say what is really important in result

    edit:
    Mr Smith is not the same as mr smith - PQ is case sensitive that is why you've option there to change "size" of letters

    btw. don't change original title except it is against of rule #1 (also don't change original text in your own post#1)
    Last edited by sandy666; 12-11-2017 at 03:12 AM.

  10. #10
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    thanks sandy666

    yes changing the case fixed it yay

    thank you again

    sorry for breaking rule #1 - I wasn't sure how to say solved.

  11. #11
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,717

    Re: Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    watch here

    addsolved01.gif

  12. #12
    Registered User
    Join Date
    12-11-2017
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    7

    Re: Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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