Hey John,
Thank you for your time and interest! My story and task has remarkable parallels to your story; I am a "Bean Counter" (haha) and we recently did an accounting system "upgrade" and I am sorting through several accounts trying to label any entries that haven't been cleared yet (with the colors in the word doc).
You have definitely pinpointed the problem I am having - in Step #13 (#14,etc haven't been tested). One thing I am trying right now: Before running the macro, rewrite the "PreviousMatch = MatchRow + 1" in step #13 to be "PreviousMatch = MatchRow", and then a different error comes up much later in the dataset (same loop).
TCfind = ActiveCell.Offset(0, 8).Value2 evaluates to (13,221,361)
LCfind = ActiveCell.Offset(0, 10).Value2 evaluates to (8,213,556)
GCfind = ActiveCell.Offset(0, 12).Value2 evaluates to (13,221,261)
CurrentPC = ActiveCell.Offset(0, -6) evaluates to P4209
CurrentRow = ActiveCell.Row evaluates to 152
Step 13 is trying to find two entries within the dataset that offset each other in all three currencies (TransactionC,LocalC,GroupC) - one with document type "UE" and the other "AB"; the entries must be within the same "profit center" (P****) and neither can have been identified as a match to any of the steps before 13 (so column "activecell.offset(0,20) = "" - in the If statement)
I tried to set the loop up to find the number of offsetting TC amounts, then to search through each of those matches to see if the other criteria are matched as well.
I've tried very hard to get this to work, and honestly believe I should pay someone for their efforts to have this work. Please let me know what you think Thanks John!
Adam
Bookmarks