Validation Between 2 Sheets

  • Hello,


    I have a document where I paste a report (Account number, Debit, Credit, Net Change, Balance) from our company's accounting system into a tab and all other tabs (there are 8) vlookup the values based on account number into a nicely formatted report. I need to ensure that all the accounts in the other tabs have values, as well as ensure that all accounts from the accounting system report show on atleast one of the other reports. (Essentially a back and forth check to ensure that all accounts show on both the accounting report and the smaller sheets)


    I would prefer to avoid VB but would be open to marcos


    Thanks,


    Mike Z