Hello,

I maintain a monthly workbook that tracks daily deposits. Some of
those deposits are electronically posted (aka: 835s) and some are posted by
hand. The IT dept uses a separate workbook to enter batch #s, dollar
amounts, & ect. for the 835 batches. Some of the 835s are electronically
deposited and some are checks. IT holds check batches until the check along
with the payment detail come in. Is there a way for excel to put an X in a
column of the IT dept's spreadsheet when we enter an 835 on our spreadsheet
so they'll know when a check comes in and they can post that batch?

Thank you