Sheets(
"Übergabeliste"
).Range(
"C2"
).FormulaR1C1 =
"=VLOOKUP(RC1,WTL!C1:C11,3,FALSE)"
Sheets(
"Übergabeliste"
).Range(
"D2"
).FormulaR1C1 =
"=VLOOKUP(RC1,WTL!C1:C11,4,FALSE)"
Sheets(
"Übergabeliste"
).Range(
"K2"
).FormulaR1C1 =
"=VLOOKUP(RC1,WTL!C1:C11,11,FALSE)"
Sheets(
"Übergabeliste"
).Range(
"S2"
).FormulaR1C1 =
"=VLOOKUP(RC1,WTL!C1:C14,14,FALSE)"
Sheets(
"Übergabeliste"
).Range(
"T2"
).FormulaR1C1 =
"=VLOOKUP(RC1,WTL!C1:C15,15,FALSE)"
Sheets(
"Übergabeliste"
).Range(
"U2"
).FormulaR1C1 =
"=VLOOKUP(C[-1],KOGR!C[-20]:C[-19],2,FALSE)"