Match names between two sheets

Hello experts,

How do I link 2 spreadsheets together? I don't know if I used the term "link" correctly. As you can see, I created 2 sheets, there are name that the same and there are name in spreadsheet 2 that aren't in spreadsheet 1.

I know the first step that I need to do is to seperate first and last name in 2 columns then how do I tell the Excel to let me know that Bob Smith is not in Spreadsheet 2?

Thank you for all your help!

Sheet 1:

Name

Alice Jone
Bob Smith
Claire Kennedy
Robert Cane
Amanda Chang

Spreadsheet 2:

Alice Jone
Joe Adam
Claire Kennedy
Robert Cane
Julie Nguyen
Michael Hoang

Thank you so much Jeff!!!

One more question, if the 2 spreadsheets are small then it would be easier for me to insert new line (new name) but if I have about 1000 lines, it would be time consuming to check each line to see which name is missing so I can add to a new spreadsheet. Would you show me the fastest way to know which name that missing so I can add lines?

Thanks again Jeff!!!

I think the fastest way is to apply autofilter to column B of Sheet1, and select 0 from the filter drop-down. Then highlight the visible names in column A, click <copy>, then click on Sheet2, column A, press <end> followed by down-arrow then down-arrow to move to the next empty cell then press <enter> to paste your list in there.

Hope this helps.

Pete

Jeff,

I just started a new job so they expected me to know a lot with Excel formula and etc... I will try to get the sample spreadsheets and will post it here.

As alwas, THANK YOU for your help!!!

Best regards,

Julie

Hello Pete!

I'm lost at this part "Sheet2, column A, press <end> followed by down-arrow then down-arrow to move to the next empty cell then press <enter> to paste your list in there."

It would be easier if I have sample spreadsheets, I will post it when I have it ready.

Thank your for your help.

That part means to select Sheet2 by clicking on the tab (you were in Sheet1, where you copied the visible names), then ensure that you are in column A (where your other names are located), then press the <End> key and then the down-arrow key, (which will move you to the bottom cell containing data) then press the down-arrow key once more (which will take you into the next empty cell below your existing names), and then press the <Enter> key (which will paste the names that were filtered on Sheet1, i.e. the missing names, below your existing names on Sheet2.

Hope this helps.

Pete

Hello Jeff & Pete and other experts,

Please see reports attached. I only uploaded 2 files, 1 for September and 1 for October but I have 12 reports for 12 months of the year. Here is what I need to see:

As you can see, the October invoice, line 12 the highlighted in yellow, this line wasn't in the September invoice. And line 16, there is a Term Date . I would like to see these two report link into 1 master report, meaning the master report will show Kim Alton (line 12) and line 16 term date. The premium on column J will be a accumulate of each month premium.

Is it making any sense?

A 2nd report master that I will need is:
Take an example that line 5 (Acebu), I want the master report show 12 lines, 1 line for each month. Meaning the master report will gather all 12 reports into 1 master report that have 12 lines for each month.

As always, thank you for your help!!

Julie

Hello Jeff,

As always, thank you for your help!

I think I know what you are trying to say. Let's me take it home, "study it" and see if I can figure it out.

Again, THANK YOU!!!

You are great!!!

Julie