+ Reply to Thread
Results 1 to 4 of 4

Import data from another list

  1. 03-26-2017, 10:44 PM #1
    emilio911
    emilio911 is offline
    Registered User
    Join Date
    02-23-2017
    Location
    here
    MS-Off Ver
    2019
    Posts
    13

    Question Import data from another list

    Hello all! I'm kind of lost. How can I get list #3 from list #1 and list #2?

    Thanks all!

    list #1

    af
    ax
    al
    dz
    as
    ad
    ao
    ai
    ag
    ar
    am
    aw


    list #2

    ax coconut apple
    ha funny people
    ao citrus orange
    as phone passport
    is island pineapple
    dz keys car
    pk hello tornado


    list #3

    af
    ax coconut apple
    al
    dz keys car
    as phone passport
    ad
    ao citrus orange
    ai
    ag
    ar
    am
    aw
    Last edited by emilio911; 03-26-2017 at 10:46 PM.
    Reply With QuoteRegister To Reply
  2. 03-26-2017, 11:02 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Import data from another list

    This is one way.

    With list #1 in A3:A14, list #2 in A20:C26 put this formula for list #3 in A32 and fill down to A43. It will duplicated list #1
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Then enter this formula in B32:C43
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Dave
    Reply With QuoteRegister To Reply
  3. 03-26-2017, 11:21 PM #3
    emilio911
    emilio911 is offline
    Registered User
    Join Date
    02-23-2017
    Location
    here
    MS-Off Ver
    2019
    Posts
    13

    Re: Import data from another list

    Thanks a lot!
    Reply With QuoteRegister To Reply
  4. 03-26-2017, 11:45 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Import data from another list

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Power Pivot SQL Data Import - How to update import filter
    By minnesotaart in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2013, 12:39 PM
  2. Import data from specfic column in Sheet Sheet to List Box userform
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2013, 05:54 PM
  3. Import data from two lists into one combined list
    By ghladik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 02:53 PM
  4. VBA to Import Data based on the choice made from the drop down list
    By IamHarish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2012, 02:37 PM
  5. Dropdown List to Import Data
    By Toilet sniffer V in forum Excel General
    Replies: 2
    Last Post: 05-11-2010, 08:17 AM
  6. PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ???
    By kirkm in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-08-2006, 05:05 AM
  7. Easiest way to import sharpoint list data into excel programatically
    By Jay A. Ritchie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2006, 06:20 PM
  8. [SOLVED] Easiest way to import sharpoint list data into excel programatically
    By Jay A. Ritchie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2006, 01:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1