{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inventaire","Log","Data","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inventaire","index":0,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["كود مخزن","اسم المخزن","كود صنف","اسم الصنف","سعة الصنف","سعر شراء","رصيد المخزون",null,null,null,null,null,"تاريخ التعديل","اسم المستخدم"]
[1,"Magasin 1",100,"بسكويت",null,null,46,null,null,null,null,null,"2024-08-22T23:15:22","Pro"]
[2,"Magasin 2",100,"بسكويت",null,null,49,null,null,null,null,null,"2024-08-22T23:19:00","Pro"]
[1,"Magasin 1",101,"بسكويت 1",null,null,46,null,null,null,null,null,"2024-08-22T23:15:22","Pro"]
[2,"Magasin 2",101,"بسكويت 1",null,null,49,null,null,null,null,null,"2024-08-22T23:19:00","Pro"]

{"sheet":"Log","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["01/08/2024<=B:B","22/08/2024>=B:B","Magasin 1=E:E AND 100=H:H","#N/A","#N/A2","#N/A3","#N/A4","#N/A5","اسم الصنف","الكمية","Column1","Column2","Column3","Column4"]
[1,"2024-08-12","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",10]
[2,"2024-08-12","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",20]
[6,"2024-08-12","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[7,"2024-08-12","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",9]
[9,"2024-08-12","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",15]
[10,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[11,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[12,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[13,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",2]
[14,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",2]
[15,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",3]
[16,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[17,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
["18","17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",4]
[19,"17/08/2024","تحويلات","1","Magasin 1","2","Magasin 2",100,"بسكويت",5]
[20,"17/08/2024","تحويلات",1,"Magasin 1",2,"Magasin 2",100,"بسكويت",5]
[21,"17/08/2024","تحويلات",1,"Magasin 1",2,"Magasin 2",100,"بسكويت",5]
[22,"17/08/2024","تحويلات",1,"Magasin 1",2,"Magasin 2",100,"بسكويت",2,null,null,"2024-08-22T23:19:00","Pro"]
["00 24","22/08/2024","تم تحويل 5 من مخزن Magasin 1 إلى مخزن Magasin 2",1,"Magasin 1",2,"Magasin 2",100,"بسكويت",5,"2024-08-22T23:13:13","Pro"]

{"sheet":"Data","index":2,"n_rows":5,"n_cols":27,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"كود صنف","اسم صنف","كود مورد","اسم مورد","كود المخزن","اسم مخزن","كود صنف","اسم صنف","سعة الصنف","رصيد اول مدة","سعر شراء","سعر جملة","سعر كبار عملاء","سعر تجزئة","سعر مستهلك",null,"كود مندوب","اسم مندوب",null,"كود مندوب","كود عميل","اسم عميل",null,"نوع البيع",null,"طبيعة البيع"]
[null,100,"بسكويت",2311,"شركة المتحدة",1,"Magasin 1",100,"بسكوت",null,50,null,null,null,null,null,null,1,"ادارة",null,11,12811001,"حمدى الجبلاو",null,"جملة",null,"نقدى"]
[null,101,"بسكويت 1",null,null,2,"Magasin 2",100,"بسكوت",null,null,null,null,null,null,null,null,11,"مندوب 11",null,null,null,null,null,"تجزئة",null,"اجل"]
[null,null,null,null,null,3,"Magasin 3",101,"بسكوت 1",null,50]
[null,null,null,null,null,4,"Magasin 4",101,"بسكوت 1",null,20]

{"sheet":"Sheet3","index":3,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"عملية بحث بين تاريخين وشرطين COMBOBX",null,null,null,"يوجد اسم مخزن محول منه Combobox 1"]
[null,null,"شيت 2",null,null,null,"يوجد اسم مخزن محول اليه Combobox 1"]
[null,null,"( عمود B) تاريخ بداية : textbox1",null,null,null,"يوجد كود الصنف فى Combobox 3"]
[null,null," ( عمود B) تاريخ نهاية : textbox2",null,null,null,"يوجد اسم الصنف فى Combobox4"]
[null,null,"combobox1 : اسم عميل ( عمود E)",null,null,null,"وشيت  عمود :B به اسماء المخازن \"Stock\""]
[null,null,"combobox2 :  كود صنف  ( عمود H)",null,null,null,"اسماء المخازن"]
[null,null,"LISTBOX1 ( 8 اعمدة)",null,null,null,"مخزن 1"]
[null,null,null,null,null,null,"مخزن 2"]
[null,null,null,null,null,null,"مخزن 3"]
[null,null,null,null,null,null,"مخزن 4"]
[null,null,null,null,null,null,"وشيت  عمود :C به اكواد اصناف \"Stock\""]
[null,null,null,null,null,null,"اكواد الأصناف"]
[null,null,null,null,null,null,100]
[null,null,null,null,null,null,101]
[null,null,null,null,null,null,102]
[null,null,null,null,null,null,103]
[null,null,null,null,null,null,"اريد عند اختيار مخزن معين فى"]
[null,null,null,null,null,null," Combobox 1"]
[null,null,null,null,null,null,"مثال مخزن 1"]
[null,null,null,null,null,null,"يظهر فى Combobox 2"]
[null,null,null,null,null,null,"المخازن الأخرى دون مخزن 1"]
[null,null,null,null,null,null,"مع ربطها بكود الصنف مع عدم تكرار الصنف والمخزن المحول منه واليه"]
[null,null,null,null,null,null,"وعند اختيار كود الصنف فى  Combobox 3"]
[null,null,null,null,null,null," الخاص بالمخزن فى Combobox 1"]
[null,null,null,null,null,null,"يظهر رصيد المخزون الصنف فى textbox1 التابع لمخزن فى Combobox 1  "]
[null,null,null,null,null,null,"Vba Excel"]
[]
[null,null,null,null,null,null,"هل يمكن إضافة اسم الصنف Combobox 4عند اختيار كود الصنف من Combobox 3 مع العلم يوجد اسم الصنف فى العمود D"]
[null,null,null,null,null,null,"لان كود الصنف :C بما يقابله فى العمود: B"]
[]
[]
[]
[null,null,null,null,null,null,"فهم المطلوب وتقديم الحل بشكل تفصيلي"]
[null,null,null,null,null,null,"تحليل المطلوب"]
[null,null,null,null,null,null,"بناءً على وصفك، أنت تبني نموذج في Excel باستخدام VBA حيث:"]
[null,null,null,null,null,null," * ComboBox1: يمثل المخزن المصدر."]
[null,null,null,null,null,null," * ComboBox2: يمثل المخازن المستقبلة (كل المخازن ما عدا المخزن المحدد في ComboBox1)."]
[null,null,null,null,null,null," * ComboBox3: يمثل كود الصنف."]
[null,null,null,null,null,null," * ComboBox4: يمثل اسم الصنف."]
[null,null,null,null,null,null," * TextBox1: يعرض رصيد الصنف المحدد في المخزن المحدد."]
[null,null,null,null,null,null," * الربط: يجب أن يكون هناك ربط بين المخازن والأصناف، مع التأكد من عدم تكرار أي مجموعة من المخزن المصدر والمخزن المستقبل والصنف."]
[null,null,null,null,null,null,"الحل المقترح"]
[null,null,null,null,null,null,"البيانات:"]
[null,null,null,null,null,null,"نفترض أن لديك ورقة عمل اسمها \"Stock\" تحتوي على الأعمدة التالية:"]
[null,null,null,null,null,null," * B: اسم المخزن"]
[null,null,null,null,null,null," * C: كود الصنف"]
[null,null,null,null,null,null," * D:  اسم الصنف"]
[null,null,null,null,null,null," * G: رصيد الصنف في المخزن"]