Macro to find differences from 2 sheets and display addtions deletions in other sheet

I have a file with 2 sheets (Last week & this week). Macro needs to find the deletions from last weeks data and display Col A & D in the 'missing from last week' table in 'changes' sheet, similarly need to find the additions from last week data and display A & D in the 'added to this week' table in 'changes' sheet. Attached the sample sheet for reference. Please help

hi dee8668, welcom to Excelforum, VB option: save attachment file, goto Sheets "Changes"

Thanks for the help friend. But I am getting an odbc error

checked in Excel 2007 - no errors, everything is ok

just in case, another option, press Run button

Works Great!!! .. Thanks much