Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Course Of The Month
1 day, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Compare two worksheets and insert row
Posted on 2013-01-04
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
Please let me know if you need more information.
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
8 Comments
Active 2 days ago
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.,
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
Hope this helps clarify.
WB-Before.xlsm
Active 1 day ago
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
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
Active 1 day ago
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
gowflow
WB-Before.xlsm
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month1 day, 20 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.