Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate regularly recurring entries
I use a simple excel spreadsheet to keep track of my bank
account balance, much in the same way you would with that little booklet you get with your checks. I have set up my bank account to automatically make some transactions that recur at regular (i.e. monthly) intervals. For example, every month my bank automatically debits my account for my car insurance payment and sends that payment to the insurance company. I would like my excel spreadsheet to automatically log these regular transactions, perhaps by my programming it in some way. For example, it would be nice to be able to open up my excel file on the fourth of the month to see that payment of my monthly car insurance has automatically been logged in to the top available (i.e., empty) row. Of course, that automatic entry should not occur before some predetermined date. So, on the 31 of the previous month it should not be there. And, of course, it should be entered only once (i.e., on one line) until the next month. I have no programming experience, but I can write some basic worksheet functions. Any advice would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate regularly recurring entries
You may be able to adapt the code in this thread:
http://google.com/groups?threadm=dom...62004%40news21 ..bellnet.ca In article , "KW" wrote: I use a simple excel spreadsheet to keep track of my bank account balance, much in the same way you would with that little booklet you get with your checks. I have set up my bank account to automatically make some transactions that recur at regular (i.e. monthly) intervals. For example, every month my bank automatically debits my account for my car insurance payment and sends that payment to the insurance company. I would like my excel spreadsheet to automatically log these regular transactions, perhaps by my programming it in some way. For example, it would be nice to be able to open up my excel file on the fourth of the month to see that payment of my monthly car insurance has automatically been logged in to the top available (i.e., empty) row. Of course, that automatic entry should not occur before some predetermined date. So, on the 31 of the previous month it should not be there. And, of course, it should be entered only once (i.e., on one line) until the next month. I have no programming experience, but I can write some basic worksheet functions. Any advice would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to make 4 typical entries regularly in excel | Excel Worksheet Functions | |||
How do I create recurring entries in Excel? | Excel Worksheet Functions | |||
How do I track recurring entries in Excel? | Excel Worksheet Functions | |||
Regularly used files | Excel Discussion (Misc queries) | |||
automate entries into document from a excel database | New Users to Excel |