Compare two worksheets and insert row

I have an excel 2010 workbook with a worksheet that pulls in data from an outside source (about 150 cost codes and descriptions).  On another worksheet in the same workbook I have data in the first two columns that was copied from the first sheet originally.  When a new query is run to update the first sheet, I would like to include code that would compare the two sheets row by row and update the second sheet by inserting rows if a new cost code is found.  

Please let me know if you need more information.
Thanks
acdecalAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Hi is this what you want ? I added some more missing codes to make sure we cover boundaries. Make sure your macroes are enabled and run the button and let me know if this is what you want I am coloring the code we can change that.
gowflow
WB-Before.xlsm
0
 
gowflowCommented:
yes can you post a sample would be easier to apply code
gowflow
0
 
Robberbaron (robr)Commented:
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.,
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
acdecalAuthor Commented:
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
0
 
gowflowCommented:
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
0
 
acdecalAuthor Commented:
Yes, but I need to insert a complete new row but only copy the code and description.
0
 
acdecalAuthor Commented:
OK great.  I think that will work.
0
 
gowflowCommented:
Glad I could help.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.