First time poster...tried to search for this answer with many different search keywords and came up empty or more confused...
I have a financial spreadsheet with a fixed (frozen) column on left side of spreadsheet that has cells to track some financial goals and my current status toward completing the goal.
Finances are tracked weekly with Thursday being the 'first day of week' and the spreadsheet moves to the right of the fixed column as the weeks progress.
So if I have a 1,500.00 savings goal and the current week's savings goal has 975.00 summed/totaled from 3 different cells, I want to see 975.00 in the fixed cell/column on left side of spreadsheet.
When the week rolls into the 'next' current week and a new set of columns, I want the fixed cell to show the new savings total based on the 'next' current week cells, assuming that each week money is added to savings accounts and updated in that week's cells that track savings.
So.....how do I change my fixed cell (A12 in screenshot) references to look at 3 cells in the same 'weekly' column (D6:D9 as an example)...and that fixed cell showing my up to date savings total would then update based on the 'next week' savings total (G6:G9 as an example)
Screenshot Explanation:
Relevant cells to the problem is provided in screenshot
At left is the fixed column showing Savings Goal of 1500.00 and Current Amount of 975.00 as of week 3, 1/17/2019. That Current Amount cell is summing the cells D6:D9
At top is a cell showing weekly savings increases of 50.00.
In the middle area you will see 3 Savings accounts with the dollar amount in each account in each cell.
On 1/24/2019, another 50.00 is transferred into Savings 1 and you can see the cells in middle area reflect that new Savings total.
When 1/24/2019, or week 4 occurs, I'd like the Current cell on left side (A12) of screenshot to now look at cells G6:G9 for its new SUM....and then the same behavior should occur when the week 5, 1/31/2019 begins.
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Notes[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/17/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/24/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/31/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$150.00[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]$250.00[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Savings Goal[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]$1,500.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Current:[/TD]
[TD="align: right"]$975.00[/TD]
[TD="align: right"]$1,025.00[/TD]
[TD="align: right"]$1,075.00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$975.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
I have a financial spreadsheet with a fixed (frozen) column on left side of spreadsheet that has cells to track some financial goals and my current status toward completing the goal.
Finances are tracked weekly with Thursday being the 'first day of week' and the spreadsheet moves to the right of the fixed column as the weeks progress.
So if I have a 1,500.00 savings goal and the current week's savings goal has 975.00 summed/totaled from 3 different cells, I want to see 975.00 in the fixed cell/column on left side of spreadsheet.
When the week rolls into the 'next' current week and a new set of columns, I want the fixed cell to show the new savings total based on the 'next' current week cells, assuming that each week money is added to savings accounts and updated in that week's cells that track savings.
So.....how do I change my fixed cell (A12 in screenshot) references to look at 3 cells in the same 'weekly' column (D6:D9 as an example)...and that fixed cell showing my up to date savings total would then update based on the 'next week' savings total (G6:G9 as an example)
Screenshot Explanation:
Relevant cells to the problem is provided in screenshot
At left is the fixed column showing Savings Goal of 1500.00 and Current Amount of 975.00 as of week 3, 1/17/2019. That Current Amount cell is summing the cells D6:D9
At top is a cell showing weekly savings increases of 50.00.
In the middle area you will see 3 Savings accounts with the dollar amount in each account in each cell.
On 1/24/2019, another 50.00 is transferred into Savings 1 and you can see the cells in middle area reflect that new Savings total.
When 1/24/2019, or week 4 occurs, I'd like the Current cell on left side (A12) of screenshot to now look at cells G6:G9 for its new SUM....and then the same behavior should occur when the week 5, 1/31/2019 begins.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash | Cash | Cash | ||||||||
| Savings 1 | Savings 1 | Savings 1 | ||||||||
| Savings 2 | Savings 2 | Savings 2 | ||||||||
| Savings 3 | Savings 3 | Savings 3 | ||||||||
| Edward Jones | Edward Jones | Edward Jones | ||||||||
| Other | Other | Other | ||||||||
| Total Assets | Total Assets | Total Assets | ||||||||
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Notes[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/17/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/24/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]1/31/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]To Savings 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"]-$50.00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$150.00[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]$250.00[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: right"]$650.00[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: right"]$175.00[/TD]
[TD="align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Savings Goal[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]$1,500.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]Current:[/TD]
[TD="align: right"]$975.00[/TD]
[TD="align: right"]$1,025.00[/TD]
[TD="align: right"]$1,075.00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]$975.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
Personal Cash Flow (2)
