Need a seemingly simple macro to find differences between two columns

[Drexl27]

I have two sets of data coming from different tables in a SQL database, currently open in two different instances of Excel. There is a column named AMT_PREMIUM in both, with over 15,000 rows of data. The summed amount should be the same in both, but is slightly higher in one. One also has just 5 more rows of data, so rather than going manually through over 15,000 rows, I would like to run something that would pinpoint the rows where the data differs. Please let me know if you need any more information! Thanks in advance for the help.

[mehmetcik]

Without a sample of your spreadsheet there is not a lot that I can do to help you.

How would I approach this?

Use a Macro to:
Put a formula in an unused column that returns a 1 if there is no match.
Go to the first 1 and insert a cell to push the data down one row
see if there is a match in the next row
if so change the 1 to an X to flag the change
if not then clear the 1
Loop back and continue


Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Drexl27]

Yea, that definitely looks like it would work. Obviously I could do a check to see if the amounts in each column are equal without a macro, but I wouldn't be able to automatically push down the cells. I've attached a spreadsheet with the two columns I'm comparing. Thanks!

[mehmetcik]

Try this as a start.

Please Login or Register  to view this content.

[Drexl27]

At the moment I'm getting a Compile Error: Label not defined, highlighting "GoTo Quit" near the bottom. I very rarely use macros and thus am still a complete novice, but I'll try to see if I can fix this myself and update here if I find a solution. Thanks!