-
Comparing two worksheets with a twist
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules