I have a sheet "Daily Mail Log" where all checks and amounts are recorded in, as received, daily. I also have sheets representing every clerk that receipts in those checks/amounts, and those sheets are linked to a "daily totals' sheet. Due to auditing purposes I need to know if any checks/amounts are not receipted in within a 7 day period. So in essence I need columns E & F in "daily mail log" to match columns E & F in any of the "daily totals" sheets. Any suggestions?
Bookmarks