+ 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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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

  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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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)

Similar Threads

  1. hOW TO MERGE DATA FROM SEVERAL WORKSHEETS INTO ONE
    By Rob (SA) in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2014, 07:14 AM
  2. VBA help need to merge data from 2 worksheets into one
    By vbanewbie2014 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2014, 01:06 AM
  3. Macro to pull data from 3 other worksheets, plus filtering help
    By Thunderer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2013, 05:35 PM
  4. Excel 2007 : How do I merge data from 2 different worksheets
    By Cshadwick07 in forum Excel General
    Replies: 8
    Last Post: 06-15-2012, 01:23 PM
  5. How to merge data from 2 worksheets
    By 4joey1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2010, 09:49 AM
  6. [SOLVED] Is it possible to merge data from two worksheets?
    By Valerian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2006, 01:25 PM

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