H
handyaccountant
I am trying to enter into one column an amount for a deposit and have several
other columns populate with a breakdown of that deposit. I've used a similar
function to enter in a check number and have the formula auto populate the
date/amount/payee of the check (naturally at a computer I can't access) using
some variation of a IF(ISNA(MATCH.... function, now I need something similar.
Here is a sample of what I am working with:
A B C D
1 Sales Sales Tax Deposit
2 1/1/08 29.50 1.43 30.93
3 1/2/08 300.00 8.25 308.25
....
This table is being pulled from another sheet with all of the transactions
and totalling it for the day using the date on the left. The goal for this
formula is to be able to go down the bank statement entering only the deposit
(using here the deposit for the 2nd). Let's say the deposit cleared the bank
on the 5th, although the credit card company shows it as the 2nd. I would
like to be able to enter:
A B C D
1/5/08 308.25
And have the formula return:
A B C D
1/5/08 300.00 8.25 308.25
Of course I need to do this for hundreds of deposits within a given month,
making a formula much more desirable.
Thanks
handya
other columns populate with a breakdown of that deposit. I've used a similar
function to enter in a check number and have the formula auto populate the
date/amount/payee of the check (naturally at a computer I can't access) using
some variation of a IF(ISNA(MATCH.... function, now I need something similar.
Here is a sample of what I am working with:
A B C D
1 Sales Sales Tax Deposit
2 1/1/08 29.50 1.43 30.93
3 1/2/08 300.00 8.25 308.25
....
This table is being pulled from another sheet with all of the transactions
and totalling it for the day using the date on the left. The goal for this
formula is to be able to go down the bank statement entering only the deposit
(using here the deposit for the 2nd). Let's say the deposit cleared the bank
on the 5th, although the credit card company shows it as the 2nd. I would
like to be able to enter:
A B C D
1/5/08 308.25
And have the formula return:
A B C D
1/5/08 300.00 8.25 308.25
Of course I need to do this for hundreds of deposits within a given month,
making a formula much more desirable.
Thanks
handya