Copy formulas in columns
| Source balance |
Source balance for copyng formulas |
| Dest. Balance |
Destination balance for copyng formulas. Program will copy only lines with the same line number |
| Source formula |
Source column for copying formula (1-10) |
| Destination formula |
Destination column for copying formula from source. |
| Copy formulas unchanged |
Mean, that program will copy formulas and just and calculation for column C. Letter A will be replaced with letter C for third column
|
| Copy formulas and add prefix for intial date calculation |
Similar to previus but also all formulas get prefix X
|
Practical use of prefix X for formulas. Program takes into account only posts from initial balance on that specific date in my case 01 01 2007. On report anValue3 must be entered for Column in my case.
Post included in this report for column C must be entered in initial balance.
