أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
1 St week. A - Order No B- Product C- order Qty D- Balance Qty A -1001 B - Apple C-500 D-250 A -1001 B-Orange C-10 D500 A -1001 B Lemon C-1500 D750 A -1002 B - Apple C-1500 D-500 A -1002 B-Orange C-20 D750 A -1002 B Lemon C-3500 D102nd week. A - Order No B- Product C- order Qty D- Balance Qty A -1001 B - Apple C-500 D-350 A -1001 B-Orange C-10 D600 A -1001 B Lemon C-1500 D850 A -1002 B - Apple C-1500 D-600 A -1002 B-Orange C-20 D850 A -1002 B Lemon C-3500 D1500 how i can2nd week balance Qty pull to1st week balance Qty means order Qty Same no changes. but balance qty to be change.how to pick2nd week D(balance qty) to1st week balance Qty means2nd week balance qty showing1st week d column.
Dear Bro...thanks for your answer... sometime one product100 % delivered ..menas balance quantiy remaining0 ...100 % delivered product not showing next week outstanding ... that time how i can use above method.. above method is using when100% not delivered the product.... can you advise...
bro if you want auto update2nd week >> Balance Qty on updating1st week >> Balance Qty
try this method :-
1. choose cell for2nd week >> Balance Qty
or
click on2nd week >> Balance Qty
2. press "=" from keyboard
3. move to1st week >> Balance Qty (alternate cell)
4. press "ENTER" from keyboard
5. again click on2nd week >> Balance Qty cell on which you pressed "="
6. move mouse at right bottom corner of that cell, it will show little + sign, click on it and drag upto last value of that column, you can increase limit anytime
7. now, try to change value in1st week >> Balance Qty
8. check2nd >> Balance Qty
9. reply me if not done properly, I will help you ()