| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocalculate my share balance each month after monthly contribution
A12 = Microsoft
O12 = the market value of my microsoft shares. M12 = the number of Microsoft shares I currently own N12 = the current price of each share. G12 = the amount of money I invest into Microsoft each month ... always the same monthly investment H12 = the day of the month (call it the 1st) that I make the monthly investment .... always the same day .... unless it is not a business day I need a formula or macro that would re-calculate cell M12 after I make each monthly investment. Summary.... on May 31st, I owned 4000 Microsoft shares. On the 1st I bought 100 more. I need M12 to update to 4100 when I run the macro. Can the macro be programmed to run only once each month? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link monthly balance to summary spreadsheet | Excel Discussion (Misc queries) | |||
| monthly opening and closing balance in pivot table | Excel Discussion (Misc queries) | |||
| Month-end accounting balance out | Excel Worksheet Functions | |||
| formatting end of month on a monthly sheet | Excel Worksheet Functions | |||
| sort by month with a monthly total | Excel Discussion (Misc queries) | |||
![lehr.craig@gmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
