Validation of Account Numbers
I ma reparing a budget entry sheet with numerous general ledger account
numbers in column A. I want to validate that column A has accurate general
ledger accounts numbers. How can I compare each cell in column A to a
general ledger account code listing,let's say in colmn M? If the account code
in Column A is not in column M, then it would either stop or provide an error
listing where the comparison failed. Is this a "If-then" statement? If so,
how do I code it?
|