jessabell75
New Member
- Joined
- May 11, 2018
- Messages
- 1
I have a huge spreadsheet that updates monthly and I want to insert a column at the beginning for ease in reconciliation of the current balance and current AD. See example below...I basically want to update the date field on a monthly basis and get the current balances populated. Thinking this requires a sumproduct but I'm having trouble remembering how to set this up. Any help is appreciated!
Sheet1
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 99px;"><col style="width: 99px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 12px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Sheet1
C | D | E | F | G | H | I | J | K | L | M | |
3 | Current Month | Current | Current | Depr | AD | Balance | Depr | AD | Balance | ||
4 | 2/1/2018 | AD | Balance | 1/1/2018 | 1/1/2018 | 1/1/2018 | 2/1/2018 | 2/1/2018 | 2/1/2018 | ||
5 | 500 | 6000 | 1500 | 2500 | 3000 | 4800 | 500 | 6000 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 99px;"><col style="width: 99px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 12px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>