Quote:
Originally Posted by Purfleet
I think a left with an index and match could work
can you mock up an example so we can test it?
|
Here is the mock up, but I ran into another issue.
- The third sheet "Cross match" must display the "Common Codes" listed in the first sheet. And these codes aren't always the same of course.
- The third sheet must highlight in some way the unlisted items in either sheet.
The only thing making this difficult are missing/added items in either sheet. You will notice an item on each sheet that is unlisted in the other.