Comparing two worksheets with a twist

[austenr]

I have a new project. I need to compare two worksheets. I have a macro to do the compare but here is the problem:

I am comparing by matching social security numbers. The problem is that on one of the sheets, on the line directly under the row with a SS# there is not a SS# the information is from the SS# that is directly above it. This should not show as a discrepancy but does.

Can anyone tell me how to approach this problem? I have put a sample of the file below:

999999999 smith jim $125.00
888888888 jones sally $125.00
termination -$500.00
777777777 cherry adam $250.00


Thanks in advance for your help.

[Zack Barresse]

Hi,

We'll need more info than that. Can you zip and upload an exampe file? Strip of any sensitive data if needed. I'm not sure if you have a formula doing this, or if it is in your macro .. hence the example file. :)