Hallo ch79,

entschuldige die Wartezeit. Privatleben halt :(

Ich hab die Tabellen mir jetzt nochmal nachgebaut. Sie sehen nach den Makro auch so aus:

EXCEL1
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|       |   B   | . . . |   L   |   M   |   N   |   O   |   P   |   Q   |   R   |   S   |   T   |   U   |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   41  | KW 44 |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
| . . . |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   66  |       |       |   25  |  45   |  87   | Auto  |  Bär  |  23,8 |  23   |  111  |  Was  |  345  |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|       |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+


EXCEL2
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|       |   A   |   B   |   C   |   D   |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   2   |       |    KW 40      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   3   |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   4   |       |    KW 41      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   5   |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   6   |       |    KW 42      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   7   |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   8   |       |    KW 43      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|   9   |       |       |       |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|  10   |       |    KW 44      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|  11   |       |   25  |  45   |  87   | Auto  |  Bär  |  23,8 |  23   |  111  |  Was  |  345  |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|  12   |       |    KW 45      |       |       |       |       |       |       |       |       |       |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+

Meine Frage an dich ist nun, wo habe ich den Denkfehler, warum es bei mir geht und bei dir nicht?
Danke für dein Verständnis und ich versuche weiter das Problem zu lösen.
Gruß