B
Brown2449
I'm not sure if VLOOKUP is what I should use here or not. If so wha
syntax should I use?
I'm not sure how to explain this but I will try.
I created a checkbook and budget worksheet.
Worksheet 1 is budget.
Worksheet 2 is chkbk.
In chkbk:
Column A = Dates
Column B = Check#
Column C = Payee
Column D = (blank)
Column E = Debit
Column F = Credit
Column G = Balance (formula)
Column H = Category (drop down list from column B in budget)
In budget:
Column A = (blank)
Column B = Categories (same categories as column H in chkbk)
Column C = January Budget
Column D = January Actual
Column E = February Budget
Column F = February Actual
and so on with
Column y = December Budget
Column Z = December Actual
What I would like to do is have the amount from the debit or credi
column in chkbk worksheet automatically move to the appropriate colum
and row in the budget worksheet.
So if I enter a car payment in chkbk with a date of 2/4/2012 and debi
amount of $400.00 and category "car payment" then in the budge
worksheet it should automatically fill in the amount of $400.00 in cel
F17
(F being the column for "February Actual" and 17 being the row fo
category "car payment").
Another kicker is that it needs to keep a running tally. So If I ente
another car payment for $300.00 on the date 2/20/2012, then cell F1
should reflect $700.00 and not replace the previous $400.00 with the ne
$300.00.
I'm thinking I may need to create another worksheet to keep a runnin
total for Month and Category, then move it from there to the budge
worksheet?
I hope this makes since and if someone can help I would be ver
thankful. If I need to provide more info or clarify something, let m
know.
Thank
syntax should I use?
I'm not sure how to explain this but I will try.
I created a checkbook and budget worksheet.
Worksheet 1 is budget.
Worksheet 2 is chkbk.
In chkbk:
Column A = Dates
Column B = Check#
Column C = Payee
Column D = (blank)
Column E = Debit
Column F = Credit
Column G = Balance (formula)
Column H = Category (drop down list from column B in budget)
In budget:
Column A = (blank)
Column B = Categories (same categories as column H in chkbk)
Column C = January Budget
Column D = January Actual
Column E = February Budget
Column F = February Actual
and so on with
Column y = December Budget
Column Z = December Actual
What I would like to do is have the amount from the debit or credi
column in chkbk worksheet automatically move to the appropriate colum
and row in the budget worksheet.
So if I enter a car payment in chkbk with a date of 2/4/2012 and debi
amount of $400.00 and category "car payment" then in the budge
worksheet it should automatically fill in the amount of $400.00 in cel
F17
(F being the column for "February Actual" and 17 being the row fo
category "car payment").
Another kicker is that it needs to keep a running tally. So If I ente
another car payment for $300.00 on the date 2/20/2012, then cell F1
should reflect $700.00 and not replace the previous $400.00 with the ne
$300.00.
I'm thinking I may need to create another worksheet to keep a runnin
total for Month and Category, then move it from there to the budge
worksheet?
I hope this makes since and if someone can help I would be ver
thankful. If I need to provide more info or clarify something, let m
know.
Thank
