Need assistance creating more complex data verification!

It may help to upload the workbook with non-sensitive data.  I can roughly see what your code is doing, but it would greatly help to see the data structure in each of the workbooks...

Also:

1. Is your form on an the worksheet or is it a UserForm

     a. If it's a userform then we need to know the name of the textbox or combobox

2. What column is the account code located on the worksheet?  Is it in a specific cell?

3. Where is the $ amount on the form?  What is the cell location or textbox name?

4. Anything else you that may be pertinent.

If you wrap the code in code tags it helps with readability:  The button that looks like this: </>