Compare two worksheets and insert row

yes can you post a sample would be easier to apply code
gowflow

A before and After sample is also helpful.
and record a macro that has the steps you would use to manually create the desired result as this gives a idea of what you are trying to achieve.,

OK, I attached a sample file and recorded a macro in module1.  The workbook is currently in a state that would result from running a new query where a row was added in the "Query Sheet" ws (row 12 in red).  The lists in columns A & B were previously identical to the lists in columns A & B in the "Related Data" ws.  I need code to run after the query to check for any changes in the "Query Sheet" and insert a corresponding row in the "Related Data" sheet.

Hope this helps clarify.
WB-Before.xlsm

Let me recap
You would get the workbook in this status ? like it is now like you posted ? and what you want to acheive is go thru the data in Querry Sheet and if it finds a code that does not exit in Related Data to simply insert it wher eit should be correct ???
gowflow

Yes, but I need to insert a complete new row but only copy the code and description.

OK great.  I think that will work.

Glad I could help.
gowflow