T
Tom5151
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
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