compare cols to find missing IDs

Thanks for bearing with this newb while I get upto speed with Excel....

I have 2 worksheets of company records each contaning a unique id.column.
One sheet is called LOAD the other is ALL.
The ID is in col D of each.
There are some records in ALL that are not in LOAD.
These are the ones I wish to find. A flag by each will be nice!
There are approx 1700 rec in one and 1500 in the other sheet.
How do I compare them to find where a record in ALL is not in LOAD sheet?

Thanks in advance this is a great resource and I hope to get my training wheels off before long!

TDD

Ah..Donkey...where to put the code?
I tried pasting into a cell as it is but the ALL!E2: is on another line so is this vb script or something not a simple xl formula?
Yes I really am a newb!
DAve

Righty ho!

Here is a file with the 2 tabs and sample data.

How to find which of those in AU did NOT make it into tab AU LOAD?

Thanks heaps!

TDD