+ 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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    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 (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,308

    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