excel help
 

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

excel help
 

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

excel help
 

Thank you for answering my post, Bob. Yes...My manager wants me to come up
with a way to have something show up on the same row as a matching dollar
amount on the IT department's spreadsheet when we enter an 835 on our
spreadsheet. The problem I'm running into is that the 835 check could be
deposited on any working day of the month. Also we put an 835 in one of 3
columns on our daily spreadsheets so I think I need to use an array. I
haven't been able to get =count(if or =vlookup to work (granny's a bit rusty
using those commands). Anyway, I thank you for any suggestions you can give
me.


"Bob Phillips" wrote:

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

excel help
 

You should be able to use a formula in row of

=IF(OR(A2=835,G2=835,K2=835),"X","")

and copy down. Just change A2, G2, K2 to your columns.

If the columns are contiguous, you could use

=IF(COUNTIF(G2:I2,835)0,"X","")

--

HTH

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


"grandmamashortlegs" wrote in
message ...
Thank you for answering my post, Bob. Yes...My manager wants me to come
up
with a way to have something show up on the same row as a matching dollar
amount on the IT department's spreadsheet when we enter an 835 on our
spreadsheet. The problem I'm running into is that the 835 check could be
deposited on any working day of the month. Also we put an 835 in one of 3
columns on our daily spreadsheets so I think I need to use an array. I
haven't been able to get =count(if or =vlookup to work (granny's a bit
rusty
using those commands). Anyway, I thank you for any suggestions you can
give
me.


"Bob Phillips" wrote:

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

excel help
 

Thank you. I'll let you know how it works.

"Bob Phillips" wrote:

You should be able to use a formula in row of

=IF(OR(A2=835,G2=835,K2=835),"X","")

and copy down. Just change A2, G2, K2 to your columns.

If the columns are contiguous, you could use

=IF(COUNTIF(G2:I2,835)0,"X","")

--

HTH

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


"grandmamashortlegs" wrote in
message ...
Thank you for answering my post, Bob. Yes...My manager wants me to come
up
with a way to have something show up on the same row as a matching dollar
amount on the IT department's spreadsheet when we enter an 835 on our
spreadsheet. The problem I'm running into is that the 835 check could be
deposited on any working day of the month. Also we put an 835 in one of 3
columns on our daily spreadsheets so I think I need to use an array. I
haven't been able to get =count(if or =vlookup to work (granny's a bit
rusty
using those commands). Anyway, I thank you for any suggestions you can
give
me.


"Bob Phillips" wrote:

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