AW: Nachfrage
26.03.2012 15:57:18
Heinz
Hallo Jochen
Hätte mir jetzt für mehrere Monate etwas gebastelt.
Nur funkt.es so leider nicht.
Könntest du bitte eine eventuelle Anpassung machen?
Danke Heinz
Sub Svereis_einfügen()
Dim a, b, c, d, e, f, g, h, i, j, k, l As Long, z As Range
'Jänner
a = 2
For Each z In Range("C3:AG3")
z.Formula = "=VLOOKUP($B$3,Jänner!$B$500:$AG$524," & a & ",0)"
a = a + 1
Next
'Februar
b = 2
For Each z In Range("C7:AE7")
z.Formula = "=VLOOKUP($B$7,Februar!$B$500:$AG$524," & b & ",0)"
b = b + 1
Next
'März
c = 2
For Each z In Range("C11:AG11")
z.Formula = "=VLOOKUP($B$7,März!$B$500:$AG$524," & c & ",0)"
c = c + 1
Next
'April
d = 2
For Each z In Range("C15:AF15")
z.Formula = "=VLOOKUP($B$7,April!$B$500:$AG$524," & d & ",0)"
d = d + 1
Next
'Mai
e = 2
For Each z In Range("C19:AG19")
z.Formula = "=VLOOKUP($B$7,Mai!$B$500:$AG$524," & e & ",0)"
e = e + 1
Next
'Juni
f = 2
For Each z In Range("C23:AF23")
z.Formula = "=VLOOKUP($B$7,Juni!$B$500:$AG$524," & f & ",0)"
f = f + 1
Next
'Juli
g = 2
For Each z In Range("C27:AG27")
z.Formula = "=VLOOKUP($B$7,Juli!$B$500:$AG$524," & g & ",0)"
g = g + 1
Next
'August
h = 2
For Each z In Range("C31:AF31")
z.Formula = "=VLOOKUP($B$7,August!$B$500:$AG$524," & h & ",0)"
h = h + 1
Next
'September
i = 2
For Each z In Range("C35:AF35")
z.Formula = "=VLOOKUP($B$7,September!$B$500:$AG$524," & i & ",0)"
i = i + 1
Next
'Oktober
j = 2
For Each z In Range("C39:AG39")
z.Formula = "=VLOOKUP($B$7,Oktober!$B$500:$AG$524," & j & ",0)"
j = j + 1
Next
'November
k = 2
For Each z In Range("C43:AF43")
z.Formula = "=VLOOKUP($B$7,November!$B$500:$AG$524," & k & ",0)"
k = k + 1
Next
'Dezember
l = 2
For Each z In Range("C47:AG47")
z.Formula = "=VLOOKUP($B$7,Dezember!$B$500:$AG$524," & l & ",0)"
l = l + 1
Next
End Sub