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

Hi danitydazzle..

So do you want the info that gets pulled from the Mock Main File.xlsx file to be inserted into a new 3rd Workbook?

Also..

voters name, address, race, phone number, etc.

Can you be exact and specific about which columns you want data pulled from..

I need all information from the Main File for that Registration Number.

Hi..

Select the Date value in Column C of your History Sheet and press the Button.. results shown on Sheet1..

Change the filepath of your Mock Main File to suit..

Please Login or Register  to view this content.

I am still unable to do this. I CAN sort and filter election date for only 3/27/2010. But now I need to pull all information from the main file for the filtered registration number only and put in a separate worksheet in the main file or a separate file. HELP.

Trying to find the simplest way to do this. Can the function vlook up work?

Quote Originally Posted by danitydazzle

Yes I tried. I am not sure how to sort the data first then use the main file to pull all of the personal information.

I am using MS Query. Thanks for the guidance. I was able to generate the first request Voters in the 3/27/2010 query. Now how do I query all voters that DID NOT in that particular election date-- 3/27/2010? The problem is the voters history file shows a list of ALL dates voted per registration number. And the Main File has a column with LAST DATE VOTED. When I queried <>3/27/2010 to remove the 3/27/2010, it returned multiple dates voted and I just need a list of names without each date voted. I hope I am making sense...

I need a list of all registered voters who did not vote on March 27, 2010. I don't need every date the voter actually voted.. Just the last date voted and all of their personal information.

Thank you. Thank you.

GUIDANCE NEEDED. Ok, I was able to make the two queries 1. 3/27/10 election date and reg number only, and 2. all voters minus 3/27/10. Each saved as .dqy. I did not save as an excel file. Then I opened excel and went to get external data source; what to choose for the new data source or dp I choose the query tab ?
I picked the query tab but it did not work or allowed me to pick two queries to join.. PLEASE ADVISE>
how do you choose the two queries and make as tables to join?

3. HOW TO DO THIS? Create a query joining the second and first query with a Left Join putting the second query on the left and the first query on the right.

4. Include the registrant number and date from the second query. Include the registrant number from the first.
5. In the criteria for the second registrant number put Is Null.