Hallo,
ich habe diese Tabelle, für die ich ein Makro schreiben muss. Das Makro sollte folgendes durchführe: Such Spalten mit "RUN", von dieser allen wor "RUN" enthalten ist, möchte ich in der nächsten Spalte nur die Zeile wo "Result" steht. In dieser Zeile von Result möchte ich die Spalten 2020 Plan , Is, Res in ein anderes workbook kopieren. In diesem workbook ist dann schlussendlich eine Zeile mit zB XXX-XX/XXXX_XXX2017-RUN 384,06 -384,06.
Das sollte für "PRE" und "AFTER" genauso funktionieren. Ich hoffe ich habe mich verständlich ausgedrückt und wäre um Hilfe sehr dankbar.
|
Year |
2020 |
2020 |
2020 |
Month |
Result |
Result |
Result |
|
EP - Plan |
EP - Is |
EP - Res |
Department |
Cont |
Num |
Mitarbeiter |
|
H |
|
Final Result |
76.876,80 |
4.325,46 |
72.551,34 |
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-RUN |
Result |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-RUN |
Name |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-RUN |
Name |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-RUN |
Result |
4 |
6 |
45 |
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-RUN |
Name |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-PRE |
Result |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-PRE |
Name |
|
|
|
GFET |
num |
SET |
XXX-XXXXX./XXX-XX/2019-PRE |
Name |
|
|
|
GFET |
num |
SET |
XXX-XX/XXXX_XXX2017-RUN |
Result |
456 |
384,06 |
-384,06 |
GFET |
num |
SET |
XXX-XX/XXXX_XXX2017-RUN |
Name |
56 |
144,27 |
-144,27 |
GFET |
num |
SET |
XXX-XX/XXXX_XXX2017-RUN |
Name |
66 |
125,18 |
-125,18 |
GFET |
num |
SET |
XXX-XX/XXXX_XXX2017-RUN |
Name |
|
|
|
GFET |
num |
SET |
XXX-XX/XXXX_XXX2017-RUN |
Name |
|
114,61 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2017-PRE |
Result |
5476 |
64 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2017-PRE |
Name |
654 |
46 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2017-PRE |
Name |
|
|
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2017-PRE |
Name |
6 |
464 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2018-RUN |
Result |
|
|
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2018-RUN |
Name |
546 |
89 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2018-RUN |
Name |
344 |
8 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2018-RUN |
Name |
98 |
7 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX-2018-RUN |
Name |
7 |
4 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-AFTER |
Result |
9 |
456 |
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-AFTER |
Name |
789 |
|
6,00 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-AFTER |
Name |
79 |
|
-114,61 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-PRE |
Result |
|
8 |
|
GFET |
num |
SET |
XXX-XX/XXXX_XX123-PRE |
Name |
|
|
70 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-PRE |
Name |
|
|
|
GFET |
num |
SET |
XXX-XX/XXXX_XX123-PRE |
Name |
|
789 |
7 |
GFET |
num |
SET |
XXX-XX/XXXX_XX123-PRE |
Name |
780 |
|
|
GFET |
num |
SET |
XX-XXX-XXX-2230--RUN |
Result |
987 |
|
|
GFET |
num |
SET |
XX-XXX-XXX-2230--RUN |
Name |
|
|
|
GFET |
num |
SET |
XX-XXX-XXX-2230--AFTER |
Result |
|
|
|
GFET |
num |
SET |
XX-XXX-XXX-2230--AFTER |
Name |
|
|
978 |
GFET |
num |
SET |
XXX_XX-XXX-2346-AFTER |
Result |
|
|
|
GFET |
num |
SET |
XXX_XX-XXX-2346-AFTER |
Name |
789 |
|
|
GFET |
num |
SET |
XX-XXXX_xXX-1002-AFTER |
Result |
780 |
80 |
78 |
GFET |
num |
SET |
XX-XXXX_xXX-1002-AFTER |
Name |
5 |
|
|
|