Dan_K_2014
Member
Hello,
I copy and paste into monthly columns Trial Balance(TB) from Accounting system. Number in TB are shown on accumulated basis.
For example, if I paste numbers for February, they represent January+February. So, in order to get February numbers, I have to go manually through 400 rows and deduct hard coded(pasted) February-January.
Can we build a formula or VBA (preferred), when I copy and paste a new month, VBA can work and adjust all numbers accordingly? Thank you,
I copy and paste into monthly columns Trial Balance(TB) from Accounting system. Number in TB are shown on accumulated basis.
For example, if I paste numbers for February, they represent January+February. So, in order to get February numbers, I have to go manually through 400 rows and deduct hard coded(pasted) February-January.
Can we build a formula or VBA (preferred), when I copy and paste a new month, VBA can work and adjust all numbers accordingly? Thank you,
January | February | February Should be | |
February= February- January | |||
Expense 1 | 8 | 20 | 12 |
Expense 2 | 7 | 30 | 23 |
Expense 4 | 6 | 24 | 18 |
Expense 300 | 9 | 28 | 19 |