Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checkbook Register and Budget Worksheet
Hello,
I am wondering if it is even possible to do what i am thinking. Currently my wife and I have set up a budget worksheet in excel and it works nicely. the problem is we have to do double entry. We have to write transactions manual in our paper transaction register and then enter then into the budget worksheet we created. We would prefer to create a transaction register worksheet that would automatically poplulate entries into the budget worksheet we have already created. Also we would want the transaction register to keep a running total to make balancing our checkbook easier. Obviously there are challenges with this. The transaction register would need to know what cell to put the register entry in, what month to put it in, etc. Not to mention that if there were two register entires for a given budget line item in one month it would need to add the two entries and populate the total in the correct cell in the budget worksheet. Is this even possible to do in excel? Any help or advice would be greatly appeciated Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbook register | Excel Discussion (Misc queries) | |||
checkbook register | New Users to Excel | |||
Checkbook Register | Excel Discussion (Misc queries) | |||
Checkbook Register template | Excel Discussion (Misc queries) | |||
How do I create a checkbook register? | New Users to Excel |