austenr
09-22-2004, 12:43 PM
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.
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.