soccerdude44
New Member
- Joined
- Jun 10, 2015
- Messages
- 9
I am trying to get my 1st sheet to be a summary of my other 5 sheets that I have within my workbook. Basically what I have done is created a spreadsheet for each type of investment account I have. Within each sheet I have put what I want my projected monthly contribution to be along with my expected average rate of return. This has given me an amount that I have as my goal that I want in each account at the end of each month. I then have a column for the actual amount I have at the end of each month. And then another column that shows the difference between the actual and goal amounts so I know how far ahead or behind I am. I have extended it down through the age of 65 on a month by month basis. What I would then like to do is have the current month difference be shown on the summary sheet (the first page) for all 5 accounts. So in the perfect world my summary sheet would have 5 different rows, one for each account, that shows the difference for each account but that can change which cell it is looking at for the difference based on what month it is without me having to manually update at the end of each month. Does that make sense?? Let me know if you have any questions.
Thanks For Your Help!
Thanks For Your Help!