Extract Unique Entries Across Multiple Sheets

Hi there! I have scoured the forum and I haven't found anything that works for this particular issue I am having though I know there is likely something already developed - I was hoping someone could help me out!

I have a pretty simple spreadsheet that logs unique serial numbers for a product in on one sheet, and out on another sheet; we have programmed the barcode scanner to enter these as such. What I need to do is collate the two lists into a final inventory on a third sheet so we have a handle on what serial numbers we still have in stock. I am continually coming up short on options, as this needs to be used by people with virtually zero Excel experience.

I have attached the Excel workbook in question, and very much appreciate all of your help!

is that what you want to achieve as result?

	A	B
1	Model	Serial Number
2	DGK45F	000001
3	DGK11F	000001
4	DGK100D	000001
5	DGK60D	000001
6	DGK150D/EPA3	000001
7	DGK25F	000001
8	DGK15F	000001
9	DGK70F	000001
10	DGK70F	000002
11	DGK45F	000010
12	DGK45F	000011
13	DGK45F	000012

Sorry, I should have been more clear.

The model numbers and serial number, I can pretty easily do with a table lookup - it's the data in column A on both the "Received" and "Shipped" tabs that needs to be compared. If we receive in a "D15601000001", that number is populated on the Received tab under the barcode scanned column - similarly, when we ship the "D15601000001", it is again populated automatically but under the Shipped tab. What I am needing to do is somehow automatically sort through the received and shipped (we would always have more received than shipped) to only display the data from column A that are unique values that hadn't shipped yet.

show the result what you want to achieve (manually created if necessary) in excel file

Here is the updated file with the needed output on the "Current Stock" sheet...

Thank you again for the help!

[deleted] forgot refresh thread

YES!! Thank you. It didn't occur to me to try using the table like that.

You are welcome

Read me Try to avoid joining to my Black List by doing this below If that takes care of your original question, & to say Thanks and for better Motivation, 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.