Are you asking for some way to automatically enter an X in one column if an
835 is entered in another?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"grandmamashortlegs" wrote in
message ...
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