Hi, I would like some help with my latest project. What I need to do is somehow compare two worksheets in the same workbook. Both worksheets are the same layout however could contain different records. Both could have well over 15000 records and roughly 60 columns.
(Note you need to run setup script to get the key column setup)
I need first to loop through my key column which is on sheets(1) Column A find the same value on sheets(2) column A if the same is not found then move the entire row to sheets(3) column B and Label sheets(3) column A “Not In Sheets(2)” I then need to Loop through and check Sheets(2) column A with Sheets(1) column (A) if the same is not found then move that entire row to sheets(3) columns B and label sheets(3) column A “Not In Sheets(1)” Next comes a harder task I then need to again loop through each row on sheets(1) column A Find the same on Sheets(2) columns A then loop through each column (B to last column) on sheets(2) checking if the value is the same on the same row and column from sheets(1) if the value is not the same then I need to highlight the cell on both worksheets and continue checking the current row and col then move the entire row from both worksheets to sheets(3) column B and mark sheets(3) Column A “Has changed from Sheets.name”
Not sure if this can be done all together or need separate scripts, here is what I have been trying to work with. Doesn't seem to be working just right, I also included a small workbook with some test data.
Any help someone can provide would be great.
Thank You,
Bookmarks