Wie muss ich mittels VBA vorgehen, um die Berechnung in der Beispieldatei hinzukriegen?
Das Problem liegt vor allem beim Überspringen der leeren Zeilen.
https://www.herber.de/bbs/user/71140.xls
Danke und Gruss
Frédéric
A | B | C | D | E | F | |
9 | 46'200.27 | 87'505.79 | ||||
10 | 41'838.08 | 41'305.52 | ||||
11 | 1'415.05 | -532.56 | -532.56 | |||
12 | -1'947.61 | -1'947.61 | -1947.61 | |||
13 | ||||||
14 | 22'876.27 | 73'986.12 | 73986.12 | |||
15 | 21'146.26 | 51'109.85 | 51109.85 | |||
16 | 16'289.24 | 29'963.59 | 29963.59 | |||
17 | 14'206.91 | 13'674.35 | 13674.35 | |||
18 | 1'415.05 | -532.56 | -532.56 | |||
19 | -1'947.61 | -1'947.61 | -1947.61 | |||
20 | ||||||
21 | 22'876.27 | 29'280.30 | 29280.3 | |||
22 | 21'146.26 | 6'404.03 | ||||
23 | 16'289.24 | -14'742.23 |
verwendete Formeln | |
Zelle | Formel |
C9 | =+C10+A9 |
C10 | =+C11+A10 |
C11 | =+C12+A11 |
E11 | =WENN(A11=""; ""; C12+A11) |
C12 | =+A12 |
E12 | =WENN(A12=""; ""; C13+A12) |
E13 | =WENN(A13=""; ""; C14+A13) |
C14 | =+C15+A14 |
E14 | =WENN(A14=""; ""; C15+A14) |
C15 | =+C16+A15 |
E15 | =WENN(A15=""; ""; C16+A15) |
C16 | =+C17+A16 |
E16 | =WENN(A16=""; ""; C17+A16) |
C17 | =+C18+A17 |
E17 | =WENN(A17=""; ""; C18+A17) |
C18 | =+C19+A18 |
E18 | =WENN(A18=""; ""; C19+A18) |
C19 | =+C20+A19 |
E19 | =WENN(A19=""; ""; C20+A19) |
E20 | =WENN(A20=""; ""; C21+A20) |
C21 | =+C22+A21 |
E21 | =WENN(A21=""; ""; C22+A21) |
C22 | =+C23+A22 |
C23 | =+C24+A23 |
Zahlenformate | ||
Zelle | Format | Wert |
A9 | #'##0.00_ ;[Rot]-#'##0.00 | 46200.27 |
C9 | #'##0.00_ ;[Rot]-#'##0.00 | 87505.79 |
A10 | #'##0.00_ ;[Rot]-#'##0.00 | 41838.08 |
C10 | #'##0.00_ ;[Rot]-#'##0.00 | 41305.52 |
A11 | #'##0.00_ ;[Rot]-#'##0.00 | 1415.05 |
C11 | #'##0.00_ ;[Rot]-#'##0.00 | -532.56 |
A12 | #'##0.00_ ;[Rot]-#'##0.00 | -1947.61 |
C12 | #'##0.00_ ;[Rot]-#'##0.00 | -1947.61 |
A13 | #'##0.00_ ;[Rot]-#'##0.00 | |
A14 | #'##0.00_ ;[Rot]-#'##0.00 | 22876.27 |
C14 | #'##0.00_ ;[Rot]-#'##0.00 | 73986.12 |
A15 | #'##0.00_ ;[Rot]-#'##0.00 | 21146.26 |
C15 | #'##0.00_ ;[Rot]-#'##0.00 | 51109.85 |
A16 | #'##0.00_ ;[Rot]-#'##0.00 | 16289.24 |
C16 | #'##0.00_ ;[Rot]-#'##0.00 | 29963.59 |
A17 | #'##0.00_ ;[Rot]-#'##0.00 | 14206.91 |
C17 | #'##0.00_ ;[Rot]-#'##0.00 | 13674.35 |
A18 | #'##0.00_ ;[Rot]-#'##0.00 | 1415.05 |
C18 | #'##0.00_ ;[Rot]-#'##0.00 | -532.56 |
A19 | #'##0.00_ ;[Rot]-#'##0.00 | -1947.61 |
C19 | #'##0.00_ ;[Rot]-#'##0.00 | -1947.61 |
A20 | #'##0.00_ ;[Rot]-#'##0.00 | |
A21 | #'##0.00_ ;[Rot]-#'##0.00 | 22876.27 |
C21 | #'##0.00_ ;[Rot]-#'##0.00 | 29280.3 |
A22 | #'##0.00_ ;[Rot]-#'##0.00 | 21146.26 |
C22 | #'##0.00_ ;[Rot]-#'##0.00 | 6404.02999999999 |
A23 | #'##0.00_ ;[Rot]-#'##0.00 | 16289.24 |
C23 | #'##0.00_ ;[Rot]-#'##0.00 | -14742.23 |
A | B | C | |
1 | 186.678,16 | 1.001.060,31 | |
2 | 162.849,40 | 814.382,15 | |
3 | 143.740,44 | 651.532,75 | |
4 | 135.528,14 | 507.792,31 | |
5 | 111.304,78 | 372.264,17 | |
6 | 68.539,39 | 260.959,39 | |
7 | 52.762,29 | 192.420,00 | |
8 | 52.151,92 | 139.657,71 | |
9 | 46.200,27 | 87.505,79 | |
10 | 41.838,08 | 41.305,52 | |
11 | 1.415,05 | -532,56 | |
12 | -1.947,61 | -1.947,61 | |
13 | |||
14 | 22.876,27 | 72.132,78 | |
15 | 21.146,26 | 49.256,51 |
Formeln der Tabelle | ||||
|