Sub envoyefactureaarchive()
Dim dlg As Integer
Dim cel As Range
dlg = Sheets("Archive").Range("A" & Rows.Count).End(xlUp).Row + 1
With Sheets("Archive")
    .Range("A" & dlg) = Sheets("Factures1").Range("a11")
    .Range("b" & dlg) = Sheets("Factures1").Range("b13")
    .Range("c" & dlg) = Sheets("Factures1").Range("b14")
    .Range("d" & dlg) = Sheets("Factures1").Range("b15")
    .Range("e" & dlg) = Sheets("Factures1").Range("a12")
    .Range("f" & dlg) = Sheets("Factures1").Range("a17")
    .Range("g" & dlg) = Sheets("Factures1").Range("b17")
    .Range("h" & dlg) = Sheets("Factures1").Range("c17")
    .Range("i" & dlg) = Sheets("Factures1").Range("d17")
    .Range("j" & dlg) = Sheets("Factures1").Range("e17")
    .Range("k" & dlg) = Sheets("Factures1").Range("f17")
    .Range("l" & dlg) = Sheets("Factures1").Range("g17")
    .Range("m" & dlg) = Sheets("Factures1").Range("a18")
    .Range("n" & dlg) = Sheets("Factures1").Range("b18")
    .Range("o" & dlg) = Sheets("Factures1").Range("c18")
    .Range("p" & dlg) = Sheets("Factures1").Range("d18")
    .Range("q" & dlg) = Sheets("Factures1").Range("e18")
    .Range("r" & dlg) = Sheets("Factures1").Range("f18")
    .Range("s" & dlg) = Sheets("Factures1").Range("g18")
    .Range("t" & dlg) = Sheets("Factures1").Range("a19")
    .Range("u" & dlg) = Sheets("Factures1").Range("b19")
    .Range("v" & dlg) = Sheets("Factures1").Range("c19")
    .Range("w" & dlg) = Sheets("Factures1").Range("d19")
    .Range("x" & dlg) = Sheets("Factures1").Range("e19")
    .Range("y" & dlg) = Sheets("Factures1").Range("f19")
    .Range("z" & dlg) = Sheets("Factures1").Range("g19")
    .Range("aa" & dlg) = Sheets("Factures1").Range("a20")
    .Range("ab" & dlg) = Sheets("Factures1").Range("b20")
    .Range("ac" & dlg) = Sheets("Factures1").Range("c20")
    .Range("ad" & dlg) = Sheets("Factures1").Range("d20")
    .Range("ae" & dlg) = Sheets("Factures1").Range("e20")
    .Range("af" & dlg) = Sheets("Factures1").Range("f20")
    .Range("ag" & dlg) = Sheets("Factures1").Range("g20")
    .Range("ah" & dlg) = Sheets("Factures1").Range("a21")
    .Range("ai" & dlg) = Sheets("Factures1").Range("b21")
    .Range("aj" & dlg) = Sheets("Factures1").Range("c21")
    .Range("ak" & dlg) = Sheets("Factures1").Range("d21")
    .Range("al" & dlg) = Sheets("Factures1").Range("e21")
    .Range("am" & dlg) = Sheets("Factures1").Range("f21")
    .Range("an" & dlg) = Sheets("Factures1").Range("g21")
    .Range("ao" & dlg) = Sheets("Factures1").Range("a22")
    .Range("ap" & dlg) = Sheets("Factures1").Range("b22")
    .Range("aq" & dlg) = Sheets("Factures1").Range("c22")
    .Range("ar" & dlg) = Sheets("Factures1").Range("d22")
    .Range("as" & dlg) = Sheets("Factures1").Range("e22")
    .Range("at" & dlg) = Sheets("Factures1").Range("f22")
    .Range("au" & dlg) = Sheets("Factures1").Range("g22")
    .Range("av" & dlg) = Sheets("Factures1").Range("a23")
    .Range("aw" & dlg) = Sheets("Factures1").Range("b23")
    .Range("ax" & dlg) = Sheets("Factures1").Range("c23")
    .Range("ay" & dlg) = Sheets("Factures1").Range("d23")
    .Range("az" & dlg) = Sheets("Factures1").Range("e23")
    .Range("ba" & dlg) = Sheets("Factures1").Range("f23")
    .Range("bb" & dlg) = Sheets("Factures1").Range("g23")
    .Range("bc" & dlg) = Sheets("Factures1").Range("a24")
    .Range("bd" & dlg) = Sheets("Factures1").Range("b24")
    .Range("be" & dlg) = Sheets("Factures1").Range("c24")
    .Range("bf" & dlg) = Sheets("Factures1").Range("d24")
    .Range("bg" & dlg) = Sheets("Factures1").Range("e24")
    .Range("bh" & dlg) = Sheets("Factures1").Range("f24")
    .Range("bi" & dlg) = Sheets("Factures1").Range("g24")
    .Range("bj" & dlg) = Sheets("Factures1").Range("a25")
    .Range("bk" & dlg) = Sheets("Factures1").Range("b25")
    .Range("bl" & dlg) = Sheets("Factures1").Range("c25")
    .Range("bm" & dlg) = Sheets("Factures1").Range("d25")
    .Range("bn" & dlg) = Sheets("Factures1").Range("e25")
    .Range("bo" & dlg) = Sheets("Factures1").Range("f25")
    .Range("bp" & dlg) = Sheets("Factures1").Range("g25")
    .Range("bq" & dlg) = Sheets("Factures1").Range("a26")
    .Range("br" & dlg) = Sheets("Factures1").Range("b26")
    .Range("bs" & dlg) = Sheets("Factures1").Range("c26")
    .Range("bt" & dlg) = Sheets("Factures1").Range("d26")
    .Range("bu" & dlg) = Sheets("Factures1").Range("e26")
    .Range("bv" & dlg) = Sheets("Factures1").Range("f26")
    .Range("bw" & dlg) = Sheets("Factures1").Range("g26")
    .Range("bx" & dlg) = Sheets("Factures1").Range("a27")
    .Range("by" & dlg) = Sheets("Factures1").Range("b27")
    .Range("bz" & dlg) = Sheets("Factures1").Range("c27")
    .Range("ca" & dlg) = Sheets("Factures1").Range("d27")
    .Range("cb" & dlg) = Sheets("Factures1").Range("e27")
    .Range("cc" & dlg) = Sheets("Factures1").Range("f27")
    .Range("cd" & dlg) = Sheets("Factures1").Range("g27")
    .Range("ce" & dlg) = Sheets("Factures1").Range("a28")
    .Range("cf" & dlg) = Sheets("Factures1").Range("b28")
    .Range("cg" & dlg) = Sheets("Factures1").Range("c28")
    .Range("ch" & dlg) = Sheets("Factures1").Range("d28")
    .Range("ci" & dlg) = Sheets("Factures1").Range("e28")
    .Range("cj" & dlg) = Sheets("Factures1").Range("f28")
    .Range("ck" & dlg) = Sheets("Factures1").Range("g28")
    .Range("cl" & dlg) = Sheets("Factures1").Range("a29")
    .Range("cm" & dlg) = Sheets("Factures1").Range("b29")
    .Range("cn" & dlg) = Sheets("Factures1").Range("c29")
    .Range("co" & dlg) = Sheets("Factures1").Range("d29")
    .Range("cp" & dlg) = Sheets("Factures1").Range("e29")
    .Range("cq" & dlg) = Sheets("Factures1").Range("f29")
    .Range("cr" & dlg) = Sheets("Factures1").Range("g29")
    .Range("cs" & dlg) = Sheets("Factures1").Range("a30")
    .Range("ct" & dlg) = Sheets("Factures1").Range("b30")
    .Range("cu" & dlg) = Sheets("Factures1").Range("c30")
    .Range("cv" & dlg) = Sheets("Factures1").Range("d30")
    .Range("cw" & dlg) = Sheets("Factures1").Range("e30")
    .Range("cx" & dlg) = Sheets("Factures1").Range("f30")
    .Range("cy" & dlg) = Sheets("Factures1").Range("g30")
    .Range("cz" & dlg) = Sheets("Factures1").Range("a31")
    .Range("da" & dlg) = Sheets("Factures1").Range("b31")
    .Range("db" & dlg) = Sheets("Factures1").Range("c31")
    .Range("dc" & dlg) = Sheets("Factures1").Range("d31")
    .Range("dd" & dlg) = Sheets("Factures1").Range("e31")
    .Range("de" & dlg) = Sheets("Factures1").Range("f31")
    .Range("df" & dlg) = Sheets("Factures1").Range("g31")
    .Range("dg" & dlg) = Sheets("Factures1").Range("a32")
    .Range("dh" & dlg) = Sheets("Factures1").Range("b32")
    .Range("di" & dlg) = Sheets("Factures1").Range("c32")
    .Range("dj" & dlg) = Sheets("Factures1").Range("d32")
    .Range("dk" & dlg) = Sheets("Factures1").Range("e32")
    .Range("dl" & dlg) = Sheets("Factures1").Range("f32")
    .Range("dm" & dlg) = Sheets("Factures1").Range("g32")
    .Range("dn" & dlg) = Sheets("Factures1").Range("a33")
    .Range("do" & dlg) = Sheets("Factures1").Range("b33")
    .Range("dp" & dlg) = Sheets("Factures1").Range("c33")
    .Range("dq" & dlg) = Sheets("Factures1").Range("d33")
    .Range("dr" & dlg) = Sheets("Factures1").Range("e33")
    .Range("ds" & dlg) = Sheets("Factures1").Range("f33")
    .Range("dt" & dlg) = Sheets("Factures1").Range("g33")
    .Range("du" & dlg) = Sheets("Factures1").Range("a34")
    .Range("dv" & dlg) = Sheets("Factures1").Range("b34")
    .Range("dw" & dlg) = Sheets("Factures1").Range("c34")
    .Range("dx" & dlg) = Sheets("Factures1").Range("d34")
    .Range("dy" & dlg) = Sheets("Factures1").Range("e34")
    .Range("dz" & dlg) = Sheets("Factures1").Range("f34")
    .Range("ea" & dlg) = Sheets("Factures1").Range("g34")
    .Range("eb" & dlg) = Sheets("Factures1").Range("a35")
    .Range("ec" & dlg) = Sheets("Factures1").Range("b35")
    .Range("ed" & dlg) = Sheets("Factures1").Range("c35")
    .Range("ee" & dlg) = Sheets("Factures1").Range("d35")
    .Range("ef" & dlg) = Sheets("Factures1").Range("e35")
    .Range("eg" & dlg) = Sheets("Factures1").Range("f35")
    .Range("eh" & dlg) = Sheets("Factures1").Range("g35")
    .Range("ei" & dlg) = Sheets("Factures1").Range("a36")
    .Range("ej" & dlg) = Sheets("Factures1").Range("b36")
    .Range("ek" & dlg) = Sheets("Factures1").Range("c36")
    .Range("el" & dlg) = Sheets("Factures1").Range("d36")
    .Range("em" & dlg) = Sheets("Factures1").Range("e36")
    .Range("en" & dlg) = Sheets("Factures1").Range("f36")
    .Range("eo" & dlg) = Sheets("Factures1").Range("g36")
    .Range("ep" & dlg) = Sheets("Factures1").Range("a37")
    .Range("eq" & dlg) = Sheets("Factures1").Range("b37")
    .Range("er" & dlg) = Sheets("Factures1").Range("c37")
    .Range("es" & dlg) = Sheets("Factures1").Range("d37")
    .Range("et" & dlg) = Sheets("Factures1").Range("e37")
    .Range("eu" & dlg) = Sheets("Factures1").Range("f37")
    .Range("ev" & dlg) = Sheets("Factures1").Range("g37")
    .Range("ew" & dlg) = Sheets("Factures1").Range("a38")
    .Range("ex" & dlg) = Sheets("Factures1").Range("b38")
    .Range("ey" & dlg) = Sheets("Factures1").Range("c38")
    .Range("ez" & dlg) = Sheets("Factures1").Range("d38")
    .Range("fa" & dlg) = Sheets("Factures1").Range("e38")
    .Range("fb" & dlg) = Sheets("Factures1").Range("f38")
    .Range("fc" & dlg) = Sheets("Factures1").Range("g38")
    .Range("fd" & dlg) = Sheets("Factures1").Range("a39")
    .Range("fe" & dlg) = Sheets("Factures1").Range("b39")
    .Range("ff" & dlg) = Sheets("Factures1").Range("c39")
    .Range("fg" & dlg) = Sheets("Factures1").Range("d39")
    .Range("fh" & dlg) = Sheets("Factures1").Range("e39")
    .Range("fi" & dlg) = Sheets("Factures1").Range("f39")
    .Range("fj" & dlg) = Sheets("Factures1").Range("g39")
    .Range("fk" & dlg) = Sheets("Factures1").Range("a40")
    .Range("fl" & dlg) = Sheets("Factures1").Range("b40")
    .Range("fm" & dlg) = Sheets("Factures1").Range("c40")
    .Range("fn" & dlg) = Sheets("Factures1").Range("d40")
    .Range("fo" & dlg) = Sheets("Factures1").Range("e40")
    .Range("fp" & dlg) = Sheets("Factures1").Range("f40")
    .Range("fq" & dlg) = Sheets("Factures1").Range("g40")
    .Range("fr" & dlg) = Sheets("Factures1").Range("a41")
    .Range("fs" & dlg) = Sheets("Factures1").Range("b41")
    .Range("ft" & dlg) = Sheets("Factures1").Range("c41")
    .Range("fu" & dlg) = Sheets("Factures1").Range("d41")
    .Range("fv" & dlg) = Sheets("Factures1").Range("e41")
    .Range("fw" & dlg) = Sheets("Factures1").Range("f41")
    .Range("fx" & dlg) = Sheets("Factures1").Range("g41")
    .Range("fy" & dlg) = Sheets("Factures1").Range("a42")
    .Range("fz" & dlg) = Sheets("Factures1").Range("b42")
    .Range("ga" & dlg) = Sheets("Factures1").Range("c42")
    .Range("gb" & dlg) = Sheets("Factures1").Range("d42")
    .Range("gc" & dlg) = Sheets("Factures1").Range("e42")
    .Range("gd" & dlg) = Sheets("Factures1").Range("f42")
    .Range("ge" & dlg) = Sheets("Factures1").Range("g42")
    .Range("gf" & dlg) = Sheets("Factures1").Range("a43")
    .Range("gg" & dlg) = Sheets("Factures1").Range("b43")
    .Range("gh" & dlg) = Sheets("Factures1").Range("c43")
    .Range("gi" & dlg) = Sheets("Factures1").Range("d43")
    .Range("gj" & dlg) = Sheets("Factures1").Range("e43")
    .Range("gk" & dlg) = Sheets("Factures1").Range("f43")
    .Range("gl" & dlg) = Sheets("Factures1").Range("g43")
    .Range("gm" & dlg) = Sheets("Factures1").Range("a44")
    .Range("gn" & dlg) = Sheets("Factures1").Range("b44")
    .Range("go" & dlg) = Sheets("Factures1").Range("c44")
    .Range("gp" & dlg) = Sheets("Factures1").Range("d44")
    .Range("gq" & dlg) = Sheets("Factures1").Range("e44")
    .Range("gr" & dlg) = Sheets("Factures1").Range("f44")
    .Range("gs" & dlg) = Sheets("Factures1").Range("g44")
    .Range("gt" & dlg) = Sheets("Factures1").Range("a45")
    .Range("gu" & dlg) = Sheets("Factures1").Range("b45")
    .Range("gv" & dlg) = Sheets("Factures1").Range("c45")
    .Range("gw" & dlg) = Sheets("Factures1").Range("d45")
    .Range("gx" & dlg) = Sheets("Factures1").Range("e45")
    .Range("gy" & dlg) = Sheets("Factures1").Range("f45")
    .Range("gz" & dlg) = Sheets("Factures1").Range("g45")
    .Range("ha" & dlg) = Sheets("Factures1").Range("a46")
    .Range("hb" & dlg) = Sheets("Factures1").Range("b46")
    .Range("hc" & dlg) = Sheets("Factures1").Range("c46")
    .Range("hd" & dlg) = Sheets("Factures1").Range("d46")
    .Range("he" & dlg) = Sheets("Factures1").Range("e46")
    .Range("hf" & dlg) = Sheets("Factures1").Range("f46")
    .Range("hg" & dlg) = Sheets("Factures1").Range("g46")
    .Range("hh" & dlg) = Sheets("Factures1").Range("a47")
    .Range("hi" & dlg) = Sheets("Factures1").Range("b47")
    .Range("hj" & dlg) = Sheets("Factures1").Range("c47")
    .Range("hk" & dlg) = Sheets("Factures1").Range("d47")
    .Range("hl" & dlg) = Sheets("Factures1").Range("e47")
    .Range("hm" & dlg) = Sheets("Factures1").Range("f47")
    .Range("hn" & dlg) = Sheets("Factures1").Range("g47")
    .Range("ho" & dlg) = Sheets("Factures1").Range("a48")
    .Range("hp" & dlg) = Sheets("Factures1").Range("b48")
    .Range("hq" & dlg) = Sheets("Factures1").Range("c48")
    .Range("hr" & dlg) = Sheets("Factures1").Range("d48")
    .Range("hs" & dlg) = Sheets("Factures1").Range("e48")
    .Range("ht" & dlg) = Sheets("Factures1").Range("f48")
    .Range("hu" & dlg) = Sheets("Factures1").Range("g48")
    .Range("hv" & dlg) = Sheets("Factures1").Range("a49")
    .Range("hw" & dlg) = Sheets("Factures1").Range("b49")
    .Range("hx" & dlg) = Sheets("Factures1").Range("c49")
    .Range("hy" & dlg) = Sheets("Factures1").Range("d49")
    .Range("hz" & dlg) = Sheets("Factures1").Range("e49")
    .Range("ia" & dlg) = Sheets("Factures1").Range("f49")
    .Range("ib" & dlg) = Sheets("Factures1").Range("g49")
    .Range("ic" & dlg) = Sheets("Factures1").Range("a50")
    .Range("id" & dlg) = Sheets("Factures1").Range("b50")
    .Range("ie" & dlg) = Sheets("Factures1").Range("c50")
    .Range("if" & dlg) = Sheets("Factures1").Range("d50")
    .Range("ig" & dlg) = Sheets("Factures1").Range("e50")
    .Range("ih" & dlg) = Sheets("Factures1").Range("f50")
    .Range("ii" & dlg) = Sheets("Factures1").Range("g50")
    .Range("ij" & dlg) = Sheets("Factures1").Range("a51")
    .Range("ik" & dlg) = Sheets("Factures1").Range("b51")
    .Range("jl" & dlg) = Sheets("Factures1").Range("c51")
    .Range("im" & dlg) = Sheets("Factures1").Range("d51")
    .Range("in" & dlg) = Sheets("Factures1").Range("e51")
    .Range("io" & dlg) = Sheets("Factures1").Range("f51")
    .Range("ip" & dlg) = Sheets("Factures1").Range("g51")
    .Range("iq" & dlg) = Sheets("Factures1").Range("a52")
    .Range("ir" & dlg) = Sheets("Factures1").Range("b52")
    .Range("is" & dlg) = Sheets("Factures1").Range("c52")
    .Range("it" & dlg) = Sheets("Factures1").Range("d52")
    .Range("iu" & dlg) = Sheets("Factures1").Range("e52")
    .Range("iv" & dlg) = Sheets("Factures1").Range("f52")
    .Range("iw" & dlg) = Sheets("Factures1").Range("g52")
    .Range("ix" & dlg) = Sheets("Factures1").Range("a53")
    .Range("iy" & dlg) = Sheets("Factures1").Range("b53")
    .Range("iz" & dlg) = Sheets("Factures1").Range("c53")
    .Range("ja" & dlg) = Sheets("Factures1").Range("d53")
    .Range("jb" & dlg) = Sheets("Factures1").Range("e53")
    .Range("jc" & dlg) = Sheets("Factures1").Range("f53")
    .Range("jd" & dlg) = Sheets("Factures1").Range("g53")
    .Range("je" & dlg) = Sheets("Factures1").Range("a54")
    .Range("jf" & dlg) = Sheets("Factures1").Range("b54")
    .Range("jg" & dlg) = Sheets("Factures1").Range("c54")
    .Range("jh" & dlg) = Sheets("Factures1").Range("d54")
    .Range("ji" & dlg) = Sheets("Factures1").Range("e54")
    .Range("jj" & dlg) = Sheets("Factures1").Range("f54")
    .Range("jk" & dlg) = Sheets("Factures1").Range("g54")
    .Range("jl" & dlg) = Sheets("Factures1").Range("a55")
    .Range("jm" & dlg) = Sheets("Factures1").Range("b55")
    .Range("jn" & dlg) = Sheets("Factures1").Range("c55")
    .Range("jo" & dlg) = Sheets("Factures1").Range("d55")
    .Range("jp" & dlg) = Sheets("Factures1").Range("e55")
    .Range("jq" & dlg) = Sheets("Factures1").Range("f55")
    .Range("jr" & dlg) = Sheets("Factures1").Range("g55")
    .Range("js" & dlg) = Sheets("Factures1").Range("a56")
    .Range("jt" & dlg) = Sheets("Factures1").Range("b56")
    .Range("ju" & dlg) = Sheets("Factures1").Range("c56")
    .Range("jv" & dlg) = Sheets("Factures1").Range("d56")
    .Range("jw" & dlg) = Sheets("Factures1").Range("e56")
    .Range("jx" & dlg) = Sheets("Factures1").Range("f56")
    .Range("jy" & dlg) = Sheets("Factures1").Range("g56")
    .Range("jz" & dlg) = Sheets("Factures1").Range("a57")
    .Range("ka" & dlg) = Sheets("Factures1").Range("b57")
    .Range("kb" & dlg) = Sheets("Factures1").Range("c57")
    .Range("kc" & dlg) = Sheets("Factures1").Range("d57")
    .Range("kd" & dlg) = Sheets("Factures1").Range("e57")
    .Range("ke" & dlg) = Sheets("Factures1").Range("f57")
    .Range("kf" & dlg) = Sheets("Factures1").Range("g57")
    .Range("kg" & dlg) = Sheets("Factures1").Range("a58")
    .Range("kh" & dlg) = Sheets("Factures1").Range("b58")
    .Range("ki" & dlg) = Sheets("Factures1").Range("c58")
    .Range("kj" & dlg) = Sheets("Factures1").Range("d58")
    .Range("kk" & dlg) = Sheets("Factures1").Range("e58")
    .Range("kl" & dlg) = Sheets("Factures1").Range("f58")
    .Range("km" & dlg) = Sheets("Factures1").Range("g58")
    .Range("kn" & dlg) = Sheets("Factures1").Range("a59")
    .Range("ko" & dlg) = Sheets("Factures1").Range("b59")
    .Range("kp" & dlg) = Sheets("Factures1").Range("c59")
    .Range("kq" & dlg) = Sheets("Factures1").Range("d59")
    .Range("kr" & dlg) = Sheets("Factures1").Range("e59")
    .Range("ks" & dlg) = Sheets("Factures1").Range("f59")
    .Range("kt" & dlg) = Sheets("Factures1").Range("g59")
    .Range("ku" & dlg) = Sheets("Factures1").Range("a60")
    .Range("kv" & dlg) = Sheets("Factures1").Range("b60")
    .Range("kw" & dlg) = Sheets("Factures1").Range("c60")
    .Range("kx" & dlg) = Sheets("Factures1").Range("d60")
    .Range("ky" & dlg) = Sheets("Factures1").Range("e60")
    .Range("kz" & dlg) = Sheets("Factures1").Range("f60")
    .Range("la" & dlg) = Sheets("Factures1").Range("g60")
    .Range("lb" & dlg) = Sheets("Factures1").Range("a61")
    .Range("lc" & dlg) = Sheets("Factures1").Range("b61")
    .Range("ld" & dlg) = Sheets("Factures1").Range("c61")
    .Range("le" & dlg) = Sheets("Factures1").Range("d61")
    .Range("lf" & dlg) = Sheets("Factures1").Range("e61")
    .Range("lg" & dlg) = Sheets("Factures1").Range("f61")
    .Range("lh" & dlg) = Sheets("Factures1").Range("g61")
    .Range("li" & dlg) = Sheets("Factures1").Range("a62")
    .Range("lj" & dlg) = Sheets("Factures1").Range("b62")
    .Range("lk" & dlg) = Sheets("Factures1").Range("c62")
    .Range("ll" & dlg) = Sheets("Factures1").Range("d62")
    .Range("lm" & dlg) = Sheets("Factures1").Range("e62")
    .Range("ln" & dlg) = Sheets("Factures1").Range("f62")
    .Range("lo" & dlg) = Sheets("Factures1").Range("g62")
    .Range("lp" & dlg) = Sheets("Factures1").Range("a63")
    .Range("lq" & dlg) = Sheets("Factures1").Range("b63")
    .Range("lr" & dlg) = Sheets("Factures1").Range("c63")
    .Range("ls" & dlg) = Sheets("Factures1").Range("d63")
    .Range("lt" & dlg) = Sheets("Factures1").Range("e63")
    .Range("lu" & dlg) = Sheets("Factures1").Range("f63")
    .Range("lv" & dlg) = Sheets("Factures1").Range("g63")
    .Range("lw" & dlg) = Sheets("Factures1").Range("a64")
    .Range("lx" & dlg) = Sheets("Factures1").Range("b64")
    .Range("ly" & dlg) = Sheets("Factures1").Range("c64")
    .Range("lz" & dlg) = Sheets("Factures1").Range("d64")
    .Range("ma" & dlg) = Sheets("Factures1").Range("e64")
    .Range("mb" & dlg) = Sheets("Factures1").Range("f64")
    .Range("mc" & dlg) = Sheets("Factures1").Range("g64")
    .Range("md" & dlg) = Sheets("Factures1").Range("a65")
    .Range("me" & dlg) = Sheets("Factures1").Range("b65")
    .Range("mf" & dlg) = Sheets("Factures1").Range("c65")
    .Range("mg" & dlg) = Sheets("Factures1").Range("d65")
    .Range("mh" & dlg) = Sheets("Factures1").Range("e65")
    .Range("mi" & dlg) = Sheets("Factures1").Range("f65")
    .Range("mj" & dlg) = Sheets("Factures1").Range("g65")
    .Range("mk" & dlg) = Sheets("Factures1").Range("a66")
    .Range("ml" & dlg) = Sheets("Factures1").Range("b66")
    .Range("mm" & dlg) = Sheets("Factures1").Range("c66")
    .Range("mn" & dlg) = Sheets("Factures1").Range("d66")
    .Range("mo" & dlg) = Sheets("Factures1").Range("e66")
    .Range("mp" & dlg) = Sheets("Factures1").Range("f66")
    .Range("mq" & dlg) = Sheets("Factures1").Range("g66")
    .Range("mr" & dlg) = Sheets("Factures1").Range("a67")
    .Range("ms" & dlg) = Sheets("Factures1").Range("b67")
    .Range("mt" & dlg) = Sheets("Factures1").Range("c67")
    .Range("mu" & dlg) = Sheets("Factures1").Range("d67")
    .Range("mv" & dlg) = Sheets("Factures1").Range("e67")
    .Range("mw" & dlg) = Sheets("Factures1").Range("f67")
    .Range("mx" & dlg) = Sheets("Factures1").Range("g67")
    .Range("my" & dlg) = Sheets("Factures1").Range("a68")
    .Range("mz" & dlg) = Sheets("Factures1").Range("b68")
    .Range("na" & dlg) = Sheets("Factures1").Range("c68")
    .Range("nb" & dlg) = Sheets("Factures1").Range("d68")
    .Range("nc" & dlg) = Sheets("Factures1").Range("e68")
    .Range("nd" & dlg) = Sheets("Factures1").Range("f68")
    .Range("ne" & dlg) = Sheets("Factures1").Range("g68")
    .Range("nf" & dlg) = Sheets("Factures1").Range("a69")
    .Range("ng" & dlg) = Sheets("Factures1").Range("b69")
    .Range("nh" & dlg) = Sheets("Factures1").Range("c69")
    .Range("ni" & dlg) = Sheets("Factures1").Range("d69")
    .Range("nj" & dlg) = Sheets("Factures1").Range("e69")
    .Range("nk" & dlg) = Sheets("Factures1").Range("f69")
    .Range("nl" & dlg) = Sheets("Factures1").Range("g69")
    .Range("nm" & dlg) = Sheets("Factures1").Range("a70")
    .Range("nn" & dlg) = Sheets("Factures1").Range("b70")
    .Range("no" & dlg) = Sheets("Factures1").Range("c70")
    .Range("np" & dlg) = Sheets("Factures1").Range("d70")
    .Range("nq" & dlg) = Sheets("Factures1").Range("e70")
    .Range("nr" & dlg) = Sheets("Factures1").Range("f70")
    .Range("ns" & dlg) = Sheets("Factures1").Range("g70")
    .Range("nt" & dlg) = Sheets("Factures1").Range("a71")
    .Range("nu" & dlg) = Sheets("Factures1").Range("b71")
    .Range("nv" & dlg) = Sheets("Factures1").Range("c71")
    .Range("nw" & dlg) = Sheets("Factures1").Range("d71")
    .Range("nx" & dlg) = Sheets("Factures1").Range("e71")
    .Range("ny" & dlg) = Sheets("Factures1").Range("f71")
    .Range("nz" & dlg) = Sheets("Factures1").Range("g71")
    .Range("oa" & dlg) = Sheets("Factures1").Range("a72")
    .Range("ob" & dlg) = Sheets("Factures1").Range("b72")
    .Range("oc" & dlg) = Sheets("Factures1").Range("c72")
    .Range("od" & dlg) = Sheets("Factures1").Range("d72")
    .Range("oe" & dlg) = Sheets("Factures1").Range("e72")
    .Range("of" & dlg) = Sheets("Factures1").Range("f72")
    .Range("og" & dlg) = Sheets("Factures1").Range("g72")
    .Range("oh" & dlg) = Sheets("Factures1").Range("a73")
    .Range("oi" & dlg) = Sheets("Factures1").Range("b73")
    .Range("oj" & dlg) = Sheets("Factures1").Range("c73")
    .Range("ok" & dlg) = Sheets("Factures1").Range("d73")
    .Range("ol" & dlg) = Sheets("Factures1").Range("e73")
    .Range("om" & dlg) = Sheets("Factures1").Range("f73")
    .Range("on" & dlg) = Sheets("Factures1").Range("g73")
    .Range("oo" & dlg) = Sheets("Factures1").Range("a74")
    .Range("op" & dlg) = Sheets("Factures1").Range("b74")
    .Range("oq" & dlg) = Sheets("Factures1").Range("c74")
    .Range("or" & dlg) = Sheets("Factures1").Range("d74")
    .Range("os" & dlg) = Sheets("Factures1").Range("e74")
    .Range("ot" & dlg) = Sheets("Factures1").Range("f74")
    .Range("ou" & dlg) = Sheets("Factures1").Range("g74")
    .Range("ov" & dlg) = Sheets("Factures1").Range("a75")
    .Range("ow" & dlg) = Sheets("Factures1").Range("b75")
    .Range("ox" & dlg) = Sheets("Factures1").Range("c75")
    .Range("oy" & dlg) = Sheets("Factures1").Range("d75")
    .Range("oz" & dlg) = Sheets("Factures1").Range("e75")
    .Range("pa" & dlg) = Sheets("Factures1").Range("f75")
    .Range("pb" & dlg) = Sheets("Factures1").Range("g75")
    .Range("pc" & dlg) = Sheets("Factures1").Range("a76")
    .Range("pd" & dlg) = Sheets("Factures1").Range("b76")
    .Range("pe" & dlg) = Sheets("Factures1").Range("c76")
    .Range("pf" & dlg) = Sheets("Factures1").Range("d76")
    .Range("pg" & dlg) = Sheets("Factures1").Range("e76")
    .Range("ph" & dlg) = Sheets("Factures1").Range("f76")
    .Range("pi" & dlg) = Sheets("Factures1").Range("g76")
    .Range("pj" & dlg) = Sheets("Factures1").Range("a77")
    .Range("pk" & dlg) = Sheets("Factures1").Range("b77")
    .Range("pl" & dlg) = Sheets("Factures1").Range("c77")
    .Range("pm" & dlg) = Sheets("Factures1").Range("d77")
    .Range("pn" & dlg) = Sheets("Factures1").Range("e77")
    .Range("po" & dlg) = Sheets("Factures1").Range("f77")
    .Range("pp" & dlg) = Sheets("Factures1").Range("g77")
    .Range("pq" & dlg) = Sheets("Factures1").Range("a78")
    .Range("pr" & dlg) = Sheets("Factures1").Range("b78")
    .Range("ps" & dlg) = Sheets("Factures1").Range("c78")
    .Range("pt" & dlg) = Sheets("Factures1").Range("d78")
    .Range("pu" & dlg) = Sheets("Factures1").Range("e78")
    .Range("pv" & dlg) = Sheets("Factures1").Range("f78")
    .Range("pw" & dlg) = Sheets("Factures1").Range("g78")
    .Range("px" & dlg) = Sheets("Factures1").Range("a79")
    .Range("py" & dlg) = Sheets("Factures1").Range("b79")
    .Range("pz" & dlg) = Sheets("Factures1").Range("c79")
    .Range("qa" & dlg) = Sheets("Factures1").Range("d79")
    .Range("qb" & dlg) = Sheets("Factures1").Range("e79")
    .Range("qc" & dlg) = Sheets("Factures1").Range("f79")
    .Range("qd" & dlg) = Sheets("Factures1").Range("g79")
    .Range("qe" & dlg) = Sheets("Factures1").Range("a80")
    .Range("qf" & dlg) = Sheets("Factures1").Range("b80")
    .Range("qg" & dlg) = Sheets("Factures1").Range("c80")
    .Range("qh" & dlg) = Sheets("Factures1").Range("d80")
    .Range("qi" & dlg) = Sheets("Factures1").Range("e80")
    .Range("qj" & dlg) = Sheets("Factures1").Range("f80")
    .Range("qk" & dlg) = Sheets("Factures1").Range("g80")
    .Range("ql" & dlg) = Sheets("Factures1").Range("a81")
    .Range("qm" & dlg) = Sheets("Factures1").Range("b81")
    .Range("qn" & dlg) = Sheets("Factures1").Range("c81")
    .Range("qo" & dlg) = Sheets("Factures1").Range("d81")
    .Range("qp" & dlg) = Sheets("Factures1").Range("e81")
    .Range("qq" & dlg) = Sheets("Factures1").Range("f81")
    .Range("qr" & dlg) = Sheets("Factures1").Range("g81")
    .Range("qs" & dlg) = Sheets("Factures1").Range("a82")
    .Range("qt" & dlg) = Sheets("Factures1").Range("b82")
    .Range("qu" & dlg) = Sheets("Factures1").Range("c82")
    .Range("qv" & dlg) = Sheets("Factures1").Range("d82")
    .Range("qw" & dlg) = Sheets("Factures1").Range("e82")
    .Range("qx" & dlg) = Sheets("Factures1").Range("f82")
    .Range("qy" & dlg) = Sheets("Factures1").Range("g82")
    .Range("qz" & dlg) = Sheets("Factures1").Range("a83")
    .Range("ra" & dlg) = Sheets("Factures1").Range("b83")
    .Range("rb" & dlg) = Sheets("Factures1").Range("c83")
    .Range("rc" & dlg) = Sheets("Factures1").Range("d83")
    .Range("rd" & dlg) = Sheets("Factures1").Range("e83")
    .Range("re" & dlg) = Sheets("Factures1").Range("f83")
    .Range("rf" & dlg) = Sheets("Factures1").Range("g83")
    .Range("rg" & dlg) = Sheets("Factures1").Range("a84")
    .Range("rh" & dlg) = Sheets("Factures1").Range("b84")
    .Range("ri" & dlg) = Sheets("Factures1").Range("c84")
    .Range("rj" & dlg) = Sheets("Factures1").Range("d84")
    .Range("rk" & dlg) = Sheets("Factures1").Range("e84")
    .Range("rl" & dlg) = Sheets("Factures1").Range("f84")
    .Range("rm" & dlg) = Sheets("Factures1").Range("g84")
    .Range("rn" & dlg) = Sheets("Factures1").Range("a85")
    .Range("ro" & dlg) = Sheets("Factures1").Range("b85")
    .Range("rp" & dlg) = Sheets("Factures1").Range("c85")
    .Range("rq" & dlg) = Sheets("Factures1").Range("d85")
    .Range("rr" & dlg) = Sheets("Factures1").Range("e85")
    .Range("rs" & dlg) = Sheets("Factures1").Range("f85")
    .Range("rt" & dlg) = Sheets("Factures1").Range("g85")
    .Range("ru" & dlg) = Sheets("Factures1").Range("a86")
    .Range("rv" & dlg) = Sheets("Factures1").Range("b86")
    .Range("rw" & dlg) = Sheets("Factures1").Range("c86")
    .Range("rx" & dlg) = Sheets("Factures1").Range("d86")
    .Range("ry" & dlg) = Sheets("Factures1").Range("e86")
    .Range("rz" & dlg) = Sheets("Factures1").Range("f86")
    .Range("sa" & dlg) = Sheets("Factures1").Range("g86")
    .Range("sb" & dlg) = Sheets("Factures1").Range("a87")
    .Range("sc" & dlg) = Sheets("Factures1").Range("b87")
    .Range("sd" & dlg) = Sheets("Factures1").Range("c87")
    .Range("se" & dlg) = Sheets("Factures1").Range("d87")
    .Range("sf" & dlg) = Sheets("Factures1").Range("e87")
    .Range("sg" & dlg) = Sheets("Factures1").Range("f87")
    .Range("sh" & dlg) = Sheets("Factures1").Range("g87")
    .Range("si" & dlg) = Sheets("Factures1").Range("a88")
    .Range("sj" & dlg) = Sheets("Factures1").Range("b88")
    .Range("sk" & dlg) = Sheets("Factures1").Range("c88")
    .Range("sl" & dlg) = Sheets("Factures1").Range("d88")
    .Range("sm" & dlg) = Sheets("Factures1").Range("e88")
    .Range("sn" & dlg) = Sheets("Factures1").Range("f88")
    .Range("so" & dlg) = Sheets("Factures1").Range("g88")
    .Range("sp" & dlg) = Sheets("Factures1").Range("a89")
    .Range("sq" & dlg) = Sheets("Factures1").Range("b89")
    .Range("sr" & dlg) = Sheets("Factures1").Range("c89")
    .Range("ss" & dlg) = Sheets("Factures1").Range("d89")
    .Range("st" & dlg) = Sheets("Factures1").Range("e89")
    .Range("su" & dlg) = Sheets("Factures1").Range("f89")
    .Range("sv" & dlg) = Sheets("Factures1").Range("g89")
    .Range("sw" & dlg) = Sheets("Factures1").Range("a90")
    .Range("sx" & dlg) = Sheets("Factures1").Range("b90")
    .Range("sy" & dlg) = Sheets("Factures1").Range("c90")
    .Range("tz" & dlg) = Sheets("Factures1").Range("d90")
    .Range("ta" & dlg) = Sheets("Factures1").Range("e90")
    .Range("tb" & dlg) = Sheets("Factures1").Range("f90")
    .Range("tc" & dlg) = Sheets("Factures1").Range("g90")
    .Range("td" & dlg) = Sheets("Factures1").Range("a91")
    .Range("te" & dlg) = Sheets("Factures1").Range("b91")
    .Range("tf" & dlg) = Sheets("Factures1").Range("c91")
    .Range("tg" & dlg) = Sheets("Factures1").Range("d91")
    .Range("th" & dlg) = Sheets("Factures1").Range("e91")
    .Range("ti" & dlg) = Sheets("Factures1").Range("f91")
    .Range("tj" & dlg) = Sheets("Factures1").Range("g91")
    .Range("tk" & dlg) = Sheets("Factures1").Range("a92")
    .Range("tl" & dlg) = Sheets("Factures1").Range("b92")
    .Range("tm" & dlg) = Sheets("Factures1").Range("c92")
    .Range("tn" & dlg) = Sheets("Factures1").Range("d92")
    .Range("to" & dlg) = Sheets("Factures1").Range("e92")
    .Range("tp" & dlg) = Sheets("Factures1").Range("f92")
    .Range("tq" & dlg) = Sheets("Factures1").Range("g92")
    .Range("tr" & dlg) = Sheets("Factures1").Range("a93")
    .Range("ts" & dlg) = Sheets("Factures1").Range("b93")
    .Range("tt" & dlg) = Sheets("Factures1").Range("c93")
    .Range("tu" & dlg) = Sheets("Factures1").Range("d93")
    .Range("tv" & dlg) = Sheets("Factures1").Range("e93")
    .Range("tw" & dlg) = Sheets("Factures1").Range("f93")
    .Range("tx" & dlg) = Sheets("Factures1").Range("g93")
    .Range("ty" & dlg) = Sheets("Factures1").Range("a94")
    .Range("tz" & dlg) = Sheets("Factures1").Range("b94")
    .Range("ua" & dlg) = Sheets("Factures1").Range("c94")
    .Range("ub" & dlg) = Sheets("Factures1").Range("d94")
    .Range("uc" & dlg) = Sheets("Factures1").Range("e94")
    .Range("ud" & dlg) = Sheets("Factures1").Range("f94")
    .Range("ue" & dlg) = Sheets("Factures1").Range("g94")
    .Range("uf" & dlg) = Sheets("Factures1").Range("a95")
    .Range("ug" & dlg) = Sheets("Factures1").Range("b95")
    .Range("uh" & dlg) = Sheets("Factures1").Range("c95")
    .Range("ui" & dlg) = Sheets("Factures1").Range("d95")
    .Range("uj" & dlg) = Sheets("Factures1").Range("e95")
    .Range("uk" & dlg) = Sheets("Factures1").Range("f95")
    .Range("ul" & dlg) = Sheets("Factures1").Range("g95")
    .Range("um" & dlg) = Sheets("Factures1").Range("a96")
    .Range("un" & dlg) = Sheets("Factures1").Range("b96")
    .Range("uo" & dlg) = Sheets("Factures1").Range("c96")
    .Range("up" & dlg) = Sheets("Factures1").Range("d96")
    .Range("uq" & dlg) = Sheets("Factures1").Range("e96")
    .Range("ur" & dlg) = Sheets("Factures1").Range("f96")
    .Range("us" & dlg) = Sheets("Factures1").Range("g96")
    .Range("ut" & dlg) = Sheets("Factures1").Range("a97")
    .Range("uu" & dlg) = Sheets("Factures1").Range("b97")
    .Range("uv" & dlg) = Sheets("Factures1").Range("c97")
    .Range("uw" & dlg) = Sheets("Factures1").Range("d97")
    .Range("ux" & dlg) = Sheets("Factures1").Range("e97")
    .Range("uy" & dlg) = Sheets("Factures1").Range("f97")
    .Range("uz" & dlg) = Sheets("Factures1").Range("g97")
    .Range("va" & dlg) = Sheets("Factures1").Range("a98")
    .Range("vb" & dlg) = Sheets("Factures1").Range("b98")
    .Range("vc" & dlg) = Sheets("Factures1").Range("c98")
    .Range("vd" & dlg) = Sheets("Factures1").Range("d98")
    .Range("ve" & dlg) = Sheets("Factures1").Range("e98")
    .Range("vf" & dlg) = Sheets("Factures1").Range("f98")
    .Range("vg" & dlg) = Sheets("Factures1").Range("g98")
    .Range("vh" & dlg) = Sheets("Factures1").Range("a99")
    .Range("vi" & dlg) = Sheets("Factures1").Range("b99")
    .Range("vj" & dlg) = Sheets("Factures1").Range("c99")
    .Range("vk" & dlg) = Sheets("Factures1").Range("d99")
    .Range("vl" & dlg) = Sheets("Factures1").Range("e99")
    .Range("vm" & dlg) = Sheets("Factures1").Range("f99")
    .Range("vn" & dlg) = Sheets("Factures1").Range("g99")
    .Range("vo" & dlg) = Sheets("Factures1").Range("a100")
    .Range("vp" & dlg) = Sheets("Factures1").Range("b100")
    .Range("vq" & dlg) = Sheets("Factures1").Range("c100")
    .Range("vr" & dlg) = Sheets("Factures1").Range("d100")
    .Range("vs" & dlg) = Sheets("Factures1").Range("e100")
    .Range("vt" & dlg) = Sheets("Factures1").Range("f100")
    .Range("vu" & dlg) = Sheets("Factures1").Range("g100")
    .Range("vv" & dlg) = Sheets("Factures1").Range("a101")
    .Range("vw" & dlg) = Sheets("Factures1").Range("b101")
    .Range("vx" & dlg) = Sheets("Factures1").Range("c101")
    .Range("vy" & dlg) = Sheets("Factures1").Range("d101")
    .Range("vz" & dlg) = Sheets("Factures1").Range("e101")
    .Range("wa" & dlg) = Sheets("Factures1").Range("f101")
    .Range("wb" & dlg) = Sheets("Factures1").Range("g101")
    .Range("wc" & dlg) = Sheets("Factures1").Range("a102")
    .Range("wd" & dlg) = Sheets("Factures1").Range("b102")
    .Range("we" & dlg) = Sheets("Factures1").Range("c102")
    .Range("wf" & dlg) = Sheets("Factures1").Range("d102")
    .Range("wg" & dlg) = Sheets("Factures1").Range("e102")
    .Range("wh" & dlg) = Sheets("Factures1").Range("f102")
    .Range("wi" & dlg) = Sheets("Factures1").Range("g102")
    .Range("wj" & dlg) = Sheets("Factures1").Range("a103")
    .Range("wk" & dlg) = Sheets("Factures1").Range("b103")
    .Range("wl" & dlg) = Sheets("Factures1").Range("c103")
    .Range("wm" & dlg) = Sheets("Factures1").Range("d103")
    .Range("wn" & dlg) = Sheets("Factures1").Range("e103")
    .Range("wo" & dlg) = Sheets("Factures1").Range("f103")
    .Range("wp" & dlg) = Sheets("Factures1").Range("g103")
    .Range("wq" & dlg) = Sheets("Factures1").Range("a104")
    .Range("wr" & dlg) = Sheets("Factures1").Range("b104")
    .Range("ws" & dlg) = Sheets("Factures1").Range("c104")
    .Range("wt" & dlg) = Sheets("Factures1").Range("d104")
    .Range("wu" & dlg) = Sheets("Factures1").Range("e104")
    .Range("wv" & dlg) = Sheets("Factures1").Range("f104")
    .Range("ww" & dlg) = Sheets("Factures1").Range("g104")
    .Range("wx" & dlg) = Sheets("Factures1").Range("a105")
    .Range("wy" & dlg) = Sheets("Factures1").Range("b105")
    .Range("wz" & dlg) = Sheets("Factures1").Range("c105")
    .Range("xa" & dlg) = Sheets("Factures1").Range("d105")
    .Range("xb" & dlg) = Sheets("Factures1").Range("e105")
    .Range("xc" & dlg) = Sheets("Factures1").Range("f105")
    .Range("xd" & dlg) = Sheets("Factures1").Range("g105")
    .Range("xe" & dlg) = Sheets("Factures1").Range("a106")
    .Range("xf" & dlg) = Sheets("Factures1").Range("b106")
    .Range("xg" & dlg) = Sheets("Factures1").Range("c106")
    .Range("xh" & dlg) = Sheets("Factures1").Range("d106")
    .Range("xi" & dlg) = Sheets("Factures1").Range("e106")
    .Range("xj" & dlg) = Sheets("Factures1").Range("f106")
    .Range("xk" & dlg) = Sheets("Factures1").Range("g106")
    .Range("xl" & dlg) = Sheets("Factures1").Range("a107")
    .Range("xm" & dlg) = Sheets("Factures1").Range("b107")
    .Range("xn" & dlg) = Sheets("Factures1").Range("c107")
    .Range("xo" & dlg) = Sheets("Factures1").Range("d107")
    .Range("xp" & dlg) = Sheets("Factures1").Range("e107")
    .Range("xq" & dlg) = Sheets("Factures1").Range("f107")
    .Range("xr" & dlg) = Sheets("Factures1").Range("g107")
    .Range("xs" & dlg) = Sheets("Factures1").Range("a108")
    .Range("xt" & dlg) = Sheets("Factures1").Range("b108")
    .Range("xu" & dlg) = Sheets("Factures1").Range("c108")
    .Range("xv" & dlg) = Sheets("Factures1").Range("d108")
    .Range("xw" & dlg) = Sheets("Factures1").Range("e108")
    .Range("xx" & dlg) = Sheets("Factures1").Range("f108")
    .Range("xy" & dlg) = Sheets("Factures1").Range("g108")
    .Range("xz" & dlg) = Sheets("Factures1").Range("a109")
    .Range("ya" & dlg) = Sheets("Factures1").Range("b109")
    .Range("yb" & dlg) = Sheets("Factures1").Range("c109")
    .Range("yc" & dlg) = Sheets("Factures1").Range("d109")
    .Range("yd" & dlg) = Sheets("Factures1").Range("e109")
    .Range("ye" & dlg) = Sheets("Factures1").Range("f109")
    .Range("yf" & dlg) = Sheets("Factures1").Range("g109")
    .Range("yg" & dlg) = Sheets("Factures1").Range("a110")
    .Range("yh" & dlg) = Sheets("Factures1").Range("b110")
    .Range("yi" & dlg) = Sheets("Factures1").Range("c110")
    .Range("yj" & dlg) = Sheets("Factures1").Range("d110")
    .Range("yk" & dlg) = Sheets("Factures1").Range("e110")
    .Range("yl" & dlg) = Sheets("Factures1").Range("f110")
    .Range("ym" & dlg) = Sheets("Factures1").Range("g110")
    .Range("yn" & dlg) = Sheets("Factures1").Range("a111")
    .Range("yo" & dlg) = Sheets("Factures1").Range("b111")
    .Range("yp" & dlg) = Sheets("Factures1").Range("c111")
    .Range("yq" & dlg) = Sheets("Factures1").Range("d111")
    .Range("yr" & dlg) = Sheets("Factures1").Range("e111")
    .Range("ys" & dlg) = Sheets("Factures1").Range("f111")
    .Range("yt" & dlg) = Sheets("Factures1").Range("g111")
    .Range("yu" & dlg) = Sheets("Factures1").Range("a112")
    .Range("yv" & dlg) = Sheets("Factures1").Range("b112")
    .Range("yw" & dlg) = Sheets("Factures1").Range("c112")
    .Range("yx" & dlg) = Sheets("Factures1").Range("d112")
    .Range("yy" & dlg) = Sheets("Factures1").Range("e112")
    .Range("yz" & dlg) = Sheets("Factures1").Range("f112")
    .Range("za" & dlg) = Sheets("Factures1").Range("g112")
    .Range("zb" & dlg) = Sheets("Factures1").Range("a113")
    .Range("zc" & dlg) = Sheets("Factures1").Range("b113")
    .Range("zd" & dlg) = Sheets("Factures1").Range("c113")
    .Range("ze" & dlg) = Sheets("Factures1").Range("d113")
    .Range("zf" & dlg) = Sheets("Factures1").Range("e113")
    .Range("zg" & dlg) = Sheets("Factures1").Range("f113")
    .Range("zh" & dlg) = Sheets("Factures1").Range("g113")
    .Range("zi" & dlg) = Sheets("Factures1").Range("a114")
    .Range("zj" & dlg) = Sheets("Factures1").Range("b114")
    .Range("zk" & dlg) = Sheets("Factures1").Range("c114")
    .Range("zl" & dlg) = Sheets("Factures1").Range("d114")
    .Range("zm" & dlg) = Sheets("Factures1").Range("e114")
    .Range("zn" & dlg) = Sheets("Factures1").Range("f114")
    .Range("zo" & dlg) = Sheets("Factures1").Range("g114")
    .Range("zp" & dlg) = Sheets("Factures1").Range("a115")
    .Range("zq" & dlg) = Sheets("Factures1").Range("b115")
    .Range("zr" & dlg) = Sheets("Factures1").Range("c115")
    .Range("zs" & dlg) = Sheets("Factures1").Range("d115")
    .Range("zt" & dlg) = Sheets("Factures1").Range("e115")
    .Range("zu" & dlg) = Sheets("Factures1").Range("f115")
    .Range("zv" & dlg) = Sheets("Factures1").Range("g115")
    .Range("zw" & dlg) = Sheets("Factures1").Range("a116")
    .Range("zx" & dlg) = Sheets("Factures1").Range("b116")
    .Range("zy" & dlg) = Sheets("Factures1").Range("c116")
    .Range("zz" & dlg) = Sheets("Factures1").Range("d116")
    .Range("aaa" & dlg) = Sheets("Factures1").Range("e116")
    .Range("aab" & dlg) = Sheets("Factures1").Range("f116")
    .Range("aac" & dlg) = Sheets("Factures1").Range("g116")
    .Range("aad" & dlg) = Sheets("Factures1").Range("a117")
    .Range("aae" & dlg) = Sheets("Factures1").Range("b117")
    .Range("aaf" & dlg) = Sheets("Factures1").Range("c117")
    .Range("aag" & dlg) = Sheets("Factures1").Range("d117")
    .Range("aah" & dlg) = Sheets("Factures1").Range("e117")
    .Range("aai" & dlg) = Sheets("Factures1").Range("f117")
    .Range("aaj" & dlg) = Sheets("Factures1").Range("g117")
    .Range("aak" & dlg) = Sheets("Factures1").Range("a118")
    .Range("aal" & dlg) = Sheets("Factures1").Range("b118")
    .Range("aam" & dlg) = Sheets("Factures1").Range("c118")
    .Range("aan" & dlg) = Sheets("Factures1").Range("d118")
    .Range("aao" & dlg) = Sheets("Factures1").Range("e118")
    .Range("aap" & dlg) = Sheets("Factures1").Range("f118")
    .Range("aaq" & dlg) = Sheets("Factures1").Range("g118")
    .Range("aar" & dlg) = Sheets("Factures1").Range("a119")
    .Range("aas" & dlg) = Sheets("Factures1").Range("b119")
    .Range("aat" & dlg) = Sheets("Factures1").Range("c119")
    .Range("aau" & dlg) = Sheets("Factures1").Range("d119")
    .Range("aav" & dlg) = Sheets("Factures1").Range("e119")
    .Range("aaw" & dlg) = Sheets("Factures1").Range("f119")
    .Range("aax" & dlg) = Sheets("Factures1").Range("g119")
    .Range("aay" & dlg) = Sheets("Factures1").Range("a120")
    .Range("aaz" & dlg) = Sheets("Factures1").Range("b120")
    .Range("aba" & dlg) = Sheets("Factures1").Range("c120")
    .Range("abb" & dlg) = Sheets("Factures1").Range("d120")
    .Range("abc" & dlg) = Sheets("Factures1").Range("e120")
    .Range("abd" & dlg) = Sheets("Factures1").Range("f120")
    .Range("abe" & dlg) = Sheets("Factures1").Range("g120")
    .Range("abf" & dlg) = Sheets("Factures1").Range("a121")
    .Range("abg" & dlg) = Sheets("Factures1").Range("b121")
    .Range("abh" & dlg) = Sheets("Factures1").Range("c121")
    .Range("abi" & dlg) = Sheets("Factures1").Range("d121")
    .Range("abj" & dlg) = Sheets("Factures1").Range("e121")
    .Range("abk" & dlg) = Sheets("Factures1").Range("f121")
    .Range("abl" & dlg) = Sheets("Factures1").Range("g121")
    .Range("abm" & dlg) = Sheets("Factures1").Range("a122")
    .Range("abn" & dlg) = Sheets("Factures1").Range("b122")
    .Range("abo" & dlg) = Sheets("Factures1").Range("c122")
    .Range("abp" & dlg) = Sheets("Factures1").Range("d122")
    .Range("abq" & dlg) = Sheets("Factures1").Range("e122")
    .Range("abr" & dlg) = Sheets("Factures1").Range("f122")
    .Range("abs" & dlg) = Sheets("Factures1").Range("g122")
    .Range("abt" & dlg) = Sheets("Factures1").Range("a123")
    .Range("abu" & dlg) = Sheets("Factures1").Range("b123")
    .Range("abv" & dlg) = Sheets("Factures1").Range("c123")
    .Range("abw" & dlg) = Sheets("Factures1").Range("d123")
    .Range("abx" & dlg) = Sheets("Factures1").Range("e123")
    .Range("aby" & dlg) = Sheets("Factures1").Range("f123")
    .Range("abz" & dlg) = Sheets("Factures1").Range("g123")
    .Range("aca" & dlg) = Sheets("Factures1").Range("a124")
    .Range("acb" & dlg) = Sheets("Factures1").Range("b124")
    .Range("acc" & dlg) = Sheets("Factures1").Range("c124")
    .Range("acd" & dlg) = Sheets("Factures1").Range("d124")
    .Range("ace" & dlg) = Sheets("Factures1").Range("e124")
    .Range("acf" & dlg) = Sheets("Factures1").Range("f124")
    .Range("acg" & dlg) = Sheets("Factures1").Range("g124")
    .Range("ach" & dlg) = Sheets("Factures1").Range("a125")
    .Range("aci" & dlg) = Sheets("Factures1").Range("b125")
    .Range("acj" & dlg) = Sheets("Factures1").Range("c125")
    .Range("ack" & dlg) = Sheets("Factures1").Range("d125")
    .Range("acl" & dlg) = Sheets("Factures1").Range("e125")
    .Range("acm" & dlg) = Sheets("Factures1").Range("f125")
    .Range("acn" & dlg) = Sheets("Factures1").Range("g125")
    .Range("aco" & dlg) = Sheets("Factures1").Range("a126")
    .Range("acp" & dlg) = Sheets("Factures1").Range("b126")
    .Range("acq" & dlg) = Sheets("Factures1").Range("c126")
    .Range("acr" & dlg) = Sheets("Factures1").Range("d126")
    .Range("acs" & dlg) = Sheets("Factures1").Range("e126")
    .Range("act" & dlg) = Sheets("Factures1").Range("f126")
    .Range("acu" & dlg) = Sheets("Factures1").Range("g126")
    .Range("acv" & dlg) = Sheets("Factures1").Range("a127")
    .Range("acw" & dlg) = Sheets("Factures1").Range("b127")
    .Range("acx" & dlg) = Sheets("Factures1").Range("c127")
    .Range("acy" & dlg) = Sheets("Factures1").Range("d127")
    .Range("acz" & dlg) = Sheets("Factures1").Range("e127")
    .Range("ada" & dlg) = Sheets("Factures1").Range("f127")
    .Range("adb" & dlg) = Sheets("Factures1").Range("g127")
    .Range("adc" & dlg) = Sheets("Factures1").Range("a128")
    .Range("add" & dlg) = Sheets("Factures1").Range("b128")
    .Range("ade" & dlg) = Sheets("Factures1").Range("c128")
    .Range("adf" & dlg) = Sheets("Factures1").Range("d128")
    .Range("adg" & dlg) = Sheets("Factures1").Range("e128")
    .Range("adh" & dlg) = Sheets("Factures1").Range("f128")
    .Range("adi" & dlg) = Sheets("Factures1").Range("g128")
    .Range("adj" & dlg) = Sheets("Factures1").Range("a129")
    .Range("adk" & dlg) = Sheets("Factures1").Range("b129")
    .Range("adl" & dlg) = Sheets("Factures1").Range("c129")
    .Range("adm" & dlg) = Sheets("Factures1").Range("d129")
    .Range("adn" & dlg) = Sheets("Factures1").Range("e129")
    .Range("ado" & dlg) = Sheets("Factures1").Range("f129")
    .Range("adp" & dlg) = Sheets("Factures1").Range("g129")
    .Range("adq" & dlg) = Sheets("Factures1").Range("a130")
    .Range("adr" & dlg) = Sheets("Factures1").Range("b130")
    .Range("ads" & dlg) = Sheets("Factures1").Range("c130")
    .Range("adt" & dlg) = Sheets("Factures1").Range("d130")
    .Range("adu" & dlg) = Sheets("Factures1").Range("e130")
    .Range("adv" & dlg) = Sheets("Factures1").Range("f130")
    .Range("adw" & dlg) = Sheets("Factures1").Range("g130")
    .Range("adx" & dlg) = Sheets("Factures1").Range("a131")
    .Range("ady" & dlg) = Sheets("Factures1").Range("b131")
    .Range("adz" & dlg) = Sheets("Factures1").Range("c131")
    .Range("aea" & dlg) = Sheets("Factures1").Range("d131")
    .Range("aeb" & dlg) = Sheets("Factures1").Range("e131")
    .Range("aec" & dlg) = Sheets("Factures1").Range("f131")
    .Range("aed" & dlg) = Sheets("Factures1").Range("g131")
    .Range("aee" & dlg) = Sheets("Factures1").Range("a132")
    .Range("aef" & dlg) = Sheets("Factures1").Range("b132")
    .Range("aeg" & dlg) = Sheets("Factures1").Range("c132")
    .Range("aeh" & dlg) = Sheets("Factures1").Range("d132")
    .Range("aei" & dlg) = Sheets("Factures1").Range("e132")
    .Range("aej" & dlg) = Sheets("Factures1").Range("f132")
    .Range("aek" & dlg) = Sheets("Factures1").Range("g132")
    .Range("ael" & dlg) = Sheets("Factures1").Range("a133")
    .Range("aem" & dlg) = Sheets("Factures1").Range("b133")
    .Range("aen" & dlg) = Sheets("Factures1").Range("c133")
    .Range("aeo" & dlg) = Sheets("Factures1").Range("d133")
    .Range("aep" & dlg) = Sheets("Factures1").Range("e133")
    .Range("aeq" & dlg) = Sheets("Factures1").Range("f133")
    .Range("aer" & dlg) = Sheets("Factures1").Range("g133")
    .Range("aes" & dlg) = Sheets("Factures1").Range("a134")
    .Range("aet" & dlg) = Sheets("Factures1").Range("b134")
    .Range("aeu" & dlg) = Sheets("Factures1").Range("c134")
    .Range("aev" & dlg) = Sheets("Factures1").Range("d134")
    .Range("aew" & dlg) = Sheets("Factures1").Range("e134")
    .Range("aex" & dlg) = Sheets("Factures1").Range("f134")
    .Range("aey" & dlg) = Sheets("Factures1").Range("g134")
    .Range("aez" & dlg) = Sheets("Factures1").Range("a135")
    .Range("afa" & dlg) = Sheets("Factures1").Range("b135")
    .Range("afb" & dlg) = Sheets("Factures1").Range("c135")
    .Range("afc" & dlg) = Sheets("Factures1").Range("d135")
    .Range("afd" & dlg) = Sheets("Factures1").Range("e135")
    .Range("afe" & dlg) = Sheets("Factures1").Range("f135")
    .Range("aff" & dlg) = Sheets("Factures1").Range("g135")
    
 Call envoyefactureaarchive1
 
End With

End Sub

Sub envoyefactureaarchive1()
Dim dlg As Integer
Dim cel As Range
dlg = Sheets("Archive").Range("A" & Rows.Count).End(xlUp).Row
With Sheets("Archive")
    .Range("afg" & dlg) = Sheets("Factures1").Range("a136")
    .Range("afh" & dlg) = Sheets("Factures1").Range("b136")
    .Range("afi" & dlg) = Sheets("Factures1").Range("c136")
    .Range("afj" & dlg) = Sheets("Factures1").Range("d136")
    .Range("afk" & dlg) = Sheets("Factures1").Range("e136")
    .Range("afl" & dlg) = Sheets("Factures1").Range("f136")
    .Range("afm" & dlg) = Sheets("Factures1").Range("g136")
    .Range("afn" & dlg) = Sheets("Factures1").Range("a137")
    .Range("afo" & dlg) = Sheets("Factures1").Range("b137")
    .Range("afp" & dlg) = Sheets("Factures1").Range("c137")
    .Range("afq" & dlg) = Sheets("Factures1").Range("d137")
    .Range("afr" & dlg) = Sheets("Factures1").Range("e137")
    .Range("afs" & dlg) = Sheets("Factures1").Range("f137")
    .Range("aft" & dlg) = Sheets("Factures1").Range("g137")
    .Range("afu" & dlg) = Sheets("Factures1").Range("a138")
    .Range("afv" & dlg) = Sheets("Factures1").Range("b138")
    .Range("afw" & dlg) = Sheets("Factures1").Range("c138")
    .Range("afx" & dlg) = Sheets("Factures1").Range("d138")
    .Range("afy" & dlg) = Sheets("Factures1").Range("e138")
    .Range("afz" & dlg) = Sheets("Factures1").Range("f138")
    .Range("aga" & dlg) = Sheets("Factures1").Range("g138")
    .Range("agb" & dlg) = Sheets("Factures1").Range("a139")
    .Range("agc" & dlg) = Sheets("Factures1").Range("b139")
    .Range("agd" & dlg) = Sheets("Factures1").Range("c139")
    .Range("age" & dlg) = Sheets("Factures1").Range("d139")
    .Range("agf" & dlg) = Sheets("Factures1").Range("e139")
    .Range("agg" & dlg) = Sheets("Factures1").Range("f139")
    .Range("agh" & dlg) = Sheets("Factures1").Range("g139")
    .Range("agi" & dlg) = Sheets("Factures1").Range("a140")
    .Range("agj" & dlg) = Sheets("Factures1").Range("b140")
    .Range("agk" & dlg) = Sheets("Factures1").Range("c140")
    .Range("agl" & dlg) = Sheets("Factures1").Range("d140")
    .Range("agm" & dlg) = Sheets("Factures1").Range("e140")
    .Range("agn" & dlg) = Sheets("Factures1").Range("f140")
    .Range("ago" & dlg) = Sheets("Factures1").Range("g140")
    .Range("agp" & dlg) = Sheets("Factures1").Range("a141")
    .Range("agq" & dlg) = Sheets("Factures1").Range("b141")
    .Range("agr" & dlg) = Sheets("Factures1").Range("c141")
    .Range("ags" & dlg) = Sheets("Factures1").Range("d141")
    .Range("agt" & dlg) = Sheets("Factures1").Range("e141")
    .Range("agu" & dlg) = Sheets("Factures1").Range("f141")
    .Range("agv" & dlg) = Sheets("Factures1").Range("g141")
    .Range("agw" & dlg) = Sheets("Factures1").Range("a142")
    .Range("agx" & dlg) = Sheets("Factures1").Range("b142")
    .Range("agy" & dlg) = Sheets("Factures1").Range("c142")
    .Range("agz" & dlg) = Sheets("Factures1").Range("d142")
    .Range("aha" & dlg) = Sheets("Factures1").Range("e142")
    .Range("ahb" & dlg) = Sheets("Factures1").Range("f142")
    .Range("ahc" & dlg) = Sheets("Factures1").Range("g142")
    .Range("ahd" & dlg) = Sheets("Factures1").Range("a143")
    .Range("ahe" & dlg) = Sheets("Factures1").Range("b143")
    .Range("ahf" & dlg) = Sheets("Factures1").Range("c143")
    .Range("ahg" & dlg) = Sheets("Factures1").Range("d143")
    .Range("ahh" & dlg) = Sheets("Factures1").Range("e143")
    .Range("ahi" & dlg) = Sheets("Factures1").Range("f143")
    .Range("ahj" & dlg) = Sheets("Factures1").Range("g143")
    .Range("ahk" & dlg) = Sheets("Factures1").Range("a144")
    .Range("ahl" & dlg) = Sheets("Factures1").Range("b144")
    .Range("ahm" & dlg) = Sheets("Factures1").Range("c144")
    .Range("ahn" & dlg) = Sheets("Factures1").Range("d144")
    .Range("aho" & dlg) = Sheets("Factures1").Range("e144")
    .Range("ahp" & dlg) = Sheets("Factures1").Range("f144")
    .Range("ahq" & dlg) = Sheets("Factures1").Range("g144")
    .Range("ahr" & dlg) = Sheets("Factures1").Range("a145")
    .Range("ahs" & dlg) = Sheets("Factures1").Range("b145")
    .Range("aht" & dlg) = Sheets("Factures1").Range("c145")
    .Range("ahu" & dlg) = Sheets("Factures1").Range("d145")
    .Range("ahv" & dlg) = Sheets("Factures1").Range("e145")
    .Range("ahw" & dlg) = Sheets("Factures1").Range("f145")
    .Range("ahx" & dlg) = Sheets("Factures1").Range("g145")
    .Range("ahy" & dlg) = Sheets("Factures1").Range("a146")
    .Range("ahz" & dlg) = Sheets("Factures1").Range("b146")
    .Range("aia" & dlg) = Sheets("Factures1").Range("c146")
    .Range("aib" & dlg) = Sheets("Factures1").Range("d146")
    .Range("aic" & dlg) = Sheets("Factures1").Range("e146")
    .Range("aid" & dlg) = Sheets("Factures1").Range("f146")
    .Range("aie" & dlg) = Sheets("Factures1").Range("g146")
    .Range("aif" & dlg) = Sheets("Factures1").Range("a147")
    .Range("aig" & dlg) = Sheets("Factures1").Range("b147")
    .Range("aih" & dlg) = Sheets("Factures1").Range("c147")
    .Range("aii" & dlg) = Sheets("Factures1").Range("d147")
    .Range("aij" & dlg) = Sheets("Factures1").Range("e147")
    .Range("aik" & dlg) = Sheets("Factures1").Range("f147")
    .Range("ail" & dlg) = Sheets("Factures1").Range("g147")
    .Range("aim" & dlg) = Sheets("Factures1").Range("a148")
    .Range("ain" & dlg) = Sheets("Factures1").Range("b148")
    .Range("aio" & dlg) = Sheets("Factures1").Range("c148")
    .Range("aip" & dlg) = Sheets("Factures1").Range("d148")
    .Range("aiq" & dlg) = Sheets("Factures1").Range("e148")
    .Range("air" & dlg) = Sheets("Factures1").Range("f148")
    .Range("ais" & dlg) = Sheets("Factures1").Range("g148")
    .Range("ait" & dlg) = Sheets("Factures1").Range("a149")
    .Range("aiu" & dlg) = Sheets("Factures1").Range("b149")
    .Range("aiv" & dlg) = Sheets("Factures1").Range("c149")
    .Range("aiw" & dlg) = Sheets("Factures1").Range("d149")
    .Range("aix" & dlg) = Sheets("Factures1").Range("e149")
    .Range("aiy" & dlg) = Sheets("Factures1").Range("f149")
    .Range("aiz" & dlg) = Sheets("Factures1").Range("g149")
    .Range("aja" & dlg) = Sheets("Factures1").Range("a150")
    .Range("ajb" & dlg) = Sheets("Factures1").Range("b150")
    .Range("ajc" & dlg) = Sheets("Factures1").Range("c150")
    .Range("ajd" & dlg) = Sheets("Factures1").Range("d150")
    .Range("aje" & dlg) = Sheets("Factures1").Range("e150")
    .Range("ajf" & dlg) = Sheets("Factures1").Range("f150")
    .Range("ajg" & dlg) = Sheets("Factures1").Range("g150")
    .Range("ajh" & dlg) = Sheets("Factures1").Range("a151")
    .Range("aji" & dlg) = Sheets("Factures1").Range("b151")
    .Range("ajj" & dlg) = Sheets("Factures1").Range("c151")
    .Range("ajk" & dlg) = Sheets("Factures1").Range("d151")
    .Range("ajl" & dlg) = Sheets("Factures1").Range("e151")
    .Range("ajm" & dlg) = Sheets("Factures1").Range("f151")
    .Range("ajn" & dlg) = Sheets("Factures1").Range("g151")
    .Range("ajo" & dlg) = Sheets("Factures1").Range("a152")
    .Range("ajp" & dlg) = Sheets("Factures1").Range("b152")
    .Range("ajq" & dlg) = Sheets("Factures1").Range("c152")
    .Range("ajr" & dlg) = Sheets("Factures1").Range("d152")
    .Range("ajs" & dlg) = Sheets("Factures1").Range("e152")
    .Range("ajt" & dlg) = Sheets("Factures1").Range("f152")
    .Range("aju" & dlg) = Sheets("Factures1").Range("g152")
    .Range("ajv" & dlg) = Sheets("Factures1").Range("a153")
    .Range("ajw" & dlg) = Sheets("Factures1").Range("b153")
    .Range("ajx" & dlg) = Sheets("Factures1").Range("c153")
    .Range("ajy" & dlg) = Sheets("Factures1").Range("d153")
    .Range("ajz" & dlg) = Sheets("Factures1").Range("e153")
    .Range("aka" & dlg) = Sheets("Factures1").Range("f153")
    .Range("akb" & dlg) = Sheets("Factures1").Range("g153")
    .Range("akc" & dlg) = Sheets("Factures1").Range("a154")
    .Range("akd" & dlg) = Sheets("Factures1").Range("b154")
    .Range("ake" & dlg) = Sheets("Factures1").Range("c154")
    .Range("akf" & dlg) = Sheets("Factures1").Range("d154")
    .Range("akg" & dlg) = Sheets("Factures1").Range("e154")
    .Range("akh" & dlg) = Sheets("Factures1").Range("f154")
    .Range("aki" & dlg) = Sheets("Factures1").Range("g154")
    .Range("akj" & dlg) = Sheets("Factures1").Range("a155")
    .Range("akk" & dlg) = Sheets("Factures1").Range("b155")
    .Range("akl" & dlg) = Sheets("Factures1").Range("c155")
    .Range("akm" & dlg) = Sheets("Factures1").Range("d155")
    .Range("akn" & dlg) = Sheets("Factures1").Range("e155")
    .Range("ako" & dlg) = Sheets("Factures1").Range("f155")
    .Range("akp" & dlg) = Sheets("Factures1").Range("g155")
    .Range("akq" & dlg) = Sheets("Factures1").Range("a156")
    .Range("akr" & dlg) = Sheets("Factures1").Range("b156")
    .Range("aks" & dlg) = Sheets("Factures1").Range("c156")
    .Range("akt" & dlg) = Sheets("Factures1").Range("d156")
    .Range("aku" & dlg) = Sheets("Factures1").Range("e156")
    .Range("akv" & dlg) = Sheets("Factures1").Range("f156")
    .Range("akw" & dlg) = Sheets("Factures1").Range("g156")
    .Range("akx" & dlg) = Sheets("Factures1").Range("a157")
    .Range("aky" & dlg) = Sheets("Factures1").Range("b157")
    .Range("akz" & dlg) = Sheets("Factures1").Range("c157")
    .Range("ala" & dlg) = Sheets("Factures1").Range("d157")
    .Range("alb" & dlg) = Sheets("Factures1").Range("e157")
    .Range("alc" & dlg) = Sheets("Factures1").Range("f157")
    .Range("ald" & dlg) = Sheets("Factures1").Range("g157")
    .Range("ale" & dlg) = Sheets("Factures1").Range("a158")
    .Range("alf" & dlg) = Sheets("Factures1").Range("b158")
    .Range("alg" & dlg) = Sheets("Factures1").Range("c158")
    .Range("alh" & dlg) = Sheets("Factures1").Range("d158")
    .Range("ali" & dlg) = Sheets("Factures1").Range("e158")
    .Range("alj" & dlg) = Sheets("Factures1").Range("f158")
    .Range("alk" & dlg) = Sheets("Factures1").Range("g158")
    .Range("all" & dlg) = Sheets("Factures1").Range("a159")
    .Range("alm" & dlg) = Sheets("Factures1").Range("b159")
    .Range("aln" & dlg) = Sheets("Factures1").Range("c159")
    .Range("alo" & dlg) = Sheets("Factures1").Range("d159")
    .Range("alp" & dlg) = Sheets("Factures1").Range("e159")
    .Range("alq" & dlg) = Sheets("Factures1").Range("f159")
    .Range("alr" & dlg) = Sheets("Factures1").Range("g159")
    .Range("als" & dlg) = Sheets("Factures1").Range("a160")
    .Range("alt" & dlg) = Sheets("Factures1").Range("b160")
    .Range("alu" & dlg) = Sheets("Factures1").Range("c160")
    .Range("alv" & dlg) = Sheets("Factures1").Range("d160")
    .Range("alw" & dlg) = Sheets("Factures1").Range("e160")
    .Range("alx" & dlg) = Sheets("Factures1").Range("f160")
    .Range("aly" & dlg) = Sheets("Factures1").Range("g160")
    .Range("alz" & dlg) = Sheets("Factures1").Range("a161")
    .Range("ama" & dlg) = Sheets("Factures1").Range("b161")
    .Range("amb" & dlg) = Sheets("Factures1").Range("c161")
    .Range("amc" & dlg) = Sheets("Factures1").Range("d161")
    .Range("amd" & dlg) = Sheets("Factures1").Range("e161")
    .Range("ame" & dlg) = Sheets("Factures1").Range("f161")
    .Range("amf" & dlg) = Sheets("Factures1").Range("g161")
    .Range("amg" & dlg) = Sheets("Factures1").Range("a162")
    .Range("amh" & dlg) = Sheets("Factures1").Range("b162")
    .Range("ami" & dlg) = Sheets("Factures1").Range("c162")
    .Range("amj" & dlg) = Sheets("Factures1").Range("d162")
    .Range("amk" & dlg) = Sheets("Factures1").Range("e162")
    .Range("aml" & dlg) = Sheets("Factures1").Range("f162")
    .Range("amm" & dlg) = Sheets("Factures1").Range("g162")
    .Range("amn" & dlg) = Sheets("Factures1").Range("a163")
    .Range("amo" & dlg) = Sheets("Factures1").Range("b163")
    .Range("amp" & dlg) = Sheets("Factures1").Range("c163")
    .Range("amq" & dlg) = Sheets("Factures1").Range("d163")
    .Range("amr" & dlg) = Sheets("Factures1").Range("e163")
    .Range("ams" & dlg) = Sheets("Factures1").Range("f163")
    .Range("amt" & dlg) = Sheets("Factures1").Range("g163")
    .Range("amu" & dlg) = Sheets("Factures1").Range("a164")
    .Range("amv" & dlg) = Sheets("Factures1").Range("b164")
    .Range("amw" & dlg) = Sheets("Factures1").Range("c164")
    .Range("amx" & dlg) = Sheets("Factures1").Range("d164")
    .Range("amy" & dlg) = Sheets("Factures1").Range("e164")
    .Range("amz" & dlg) = Sheets("Factures1").Range("f164")
    .Range("ana" & dlg) = Sheets("Factures1").Range("g164")
    .Range("anb" & dlg) = Sheets("Factures1").Range("a165")
    .Range("anc" & dlg) = Sheets("Factures1").Range("b165")
    .Range("and" & dlg) = Sheets("Factures1").Range("c165")
    .Range("ane" & dlg) = Sheets("Factures1").Range("d165")
    .Range("anf" & dlg) = Sheets("Factures1").Range("e165")
    .Range("ang" & dlg) = Sheets("Factures1").Range("f165")
    .Range("anh" & dlg) = Sheets("Factures1").Range("g165")
    .Range("ani" & dlg) = Sheets("Factures1").Range("a166")
    .Range("anj" & dlg) = Sheets("Factures1").Range("b166")
    .Range("ank" & dlg) = Sheets("Factures1").Range("c166")
    .Range("anl" & dlg) = Sheets("Factures1").Range("d166")
    .Range("anm" & dlg) = Sheets("Factures1").Range("e166")
    .Range("ann" & dlg) = Sheets("Factures1").Range("f166")
    .Range("ano" & dlg) = Sheets("Factures1").Range("g166")
    .Range("anp" & dlg) = Sheets("Factures1").Range("a167")
    .Range("anq" & dlg) = Sheets("Factures1").Range("b167")
    .Range("anr" & dlg) = Sheets("Factures1").Range("c167")
    .Range("ans" & dlg) = Sheets("Factures1").Range("d167")
    .Range("ant" & dlg) = Sheets("Factures1").Range("e167")
    .Range("anu" & dlg) = Sheets("Factures1").Range("f167")
    .Range("anv" & dlg) = Sheets("Factures1").Range("g167")
    .Range("anw" & dlg) = Sheets("Factures1").Range("a168")
    .Range("anx" & dlg) = Sheets("Factures1").Range("b168")
    .Range("any" & dlg) = Sheets("Factures1").Range("c168")
    .Range("anz" & dlg) = Sheets("Factures1").Range("d168")
    .Range("aoa" & dlg) = Sheets("Factures1").Range("e168")
    .Range("aob" & dlg) = Sheets("Factures1").Range("f168")
    .Range("aoc" & dlg) = Sheets("Factures1").Range("g168")
    .Range("aod" & dlg) = Sheets("Factures1").Range("a169")
    .Range("aoe" & dlg) = Sheets("Factures1").Range("b169")
    .Range("aof" & dlg) = Sheets("Factures1").Range("c169")
    .Range("aog" & dlg) = Sheets("Factures1").Range("d169")
    .Range("aoh" & dlg) = Sheets("Factures1").Range("e169")
    .Range("aoi" & dlg) = Sheets("Factures1").Range("f169")
    .Range("aoj" & dlg) = Sheets("Factures1").Range("g169")
    .Range("aok" & dlg) = Sheets("Factures1").Range("a170")
    .Range("aol" & dlg) = Sheets("Factures1").Range("b170")
    .Range("aom" & dlg) = Sheets("Factures1").Range("c170")
    .Range("aon" & dlg) = Sheets("Factures1").Range("d170")
    .Range("aoo" & dlg) = Sheets("Factures1").Range("e170")
    .Range("aop" & dlg) = Sheets("Factures1").Range("f170")
    .Range("aoq" & dlg) = Sheets("Factures1").Range("g170")
    .Range("aor" & dlg) = Sheets("Factures1").Range("a171")
    .Range("aos" & dlg) = Sheets("Factures1").Range("b171")
    .Range("aot" & dlg) = Sheets("Factures1").Range("c171")
    .Range("aou" & dlg) = Sheets("Factures1").Range("d171")
    .Range("aov" & dlg) = Sheets("Factures1").Range("e171")
    .Range("aow" & dlg) = Sheets("Factures1").Range("f171")
    .Range("aox" & dlg) = Sheets("Factures1").Range("g171")
    .Range("aoy" & dlg) = Sheets("Factures1").Range("a172")
    .Range("aoz" & dlg) = Sheets("Factures1").Range("b172")
    .Range("apa" & dlg) = Sheets("Factures1").Range("c172")
    .Range("apb" & dlg) = Sheets("Factures1").Range("d172")
    .Range("apc" & dlg) = Sheets("Factures1").Range("e172")
    .Range("apd" & dlg) = Sheets("Factures1").Range("f172")
    .Range("ape" & dlg) = Sheets("Factures1").Range("g172")
    .Range("aof" & dlg) = Sheets("Factures1").Range("a173")
    .Range("aog" & dlg) = Sheets("Factures1").Range("b173")
    .Range("aph" & dlg) = Sheets("Factures1").Range("c173")
    .Range("api" & dlg) = Sheets("Factures1").Range("d173")
    .Range("apj" & dlg) = Sheets("Factures1").Range("e173")
    .Range("apk" & dlg) = Sheets("Factures1").Range("f173")
    .Range("apl" & dlg) = Sheets("Factures1").Range("g173")
    
Call envoyefactureaarchive2
 
End With

End Sub