Results 1 to 17 of 17

How to Join Two Excel Files Consolidate Files

Threaded View

danitydazzle How to Join Two Excel Files... 03-06-2014, 11:17 PM
alansidman Re: How to Join Two Excel... 03-06-2014, 11:52 PM
apo Re: How to Join Two Excel... 03-07-2014, 12:38 AM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 12:46 AM
apo Re: How to Join Two Excel... 03-07-2014, 02:14 AM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 10:16 AM
alansidman Re: How to Join Two Excel... 03-07-2014, 10:29 AM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 10:47 AM
alansidman Re: How to Join Two Excel... 03-07-2014, 10:53 AM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 11:10 AM
alansidman Re: How to Join Two Excel... 03-07-2014, 12:21 PM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 02:12 PM
alansidman Re: How to Join Two Excel... 03-07-2014, 03:10 PM
alansidman Re: How to Join Two Excel... 03-07-2014, 03:04 PM
danitydazzle Re: How to Join Two Excel... 03-07-2014, 05:32 PM
alansidman Re: How to Join Two Excel... 03-07-2014, 05:36 PM
alansidman Re: How to Join Two Excel... 03-07-2014, 06:42 PM
  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to Join Two Excel Files Consolidate Files

    I have two files. One is a main file with lots of information(name, address, phone, race, etc.) The second file is a voters historical file. The two files SHARE a registration number. I am trying to sort and filter data from the historical file. Then take the SHARED registration number for the filtered data and pull all of the additional information needed from the main/master file. I do not know how to join or consolidate the two files and sort different data from the main file.

    EXAMPLE:
    From the MOCK VOTING HISTORY excel file: sort and filter all voters who voted on 3/27/2010 from the MOCK VOTERS HISTORY.

    Then take the LINKED registration number (who voted 3/27/10) from MOCK VOTING HISTORY File to find the voters name, address, race, phone number, etc. from the MOCK MAIN FILE.

    Thanks in advance,
    danitydazzle
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do I join multiple excel files into 1 file?
    By John in forum Excel General
    Replies: 7
    Last Post: 08-05-2015, 10:56 AM
  2. VBA code to consolidate multiple excel files into one workbook.
    By krazyhype19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 06:46 AM
  3. Macro to consolidate excel files in one database file
    By VKR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2013, 02:18 AM
  4. [SOLVED] How to consolidate data from multiple excel files to one from a https:// location??
    By Kiran2012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2012, 05:49 AM
  5. Replies: 4
    Last Post: 03-15-2007, 06:53 PM

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