nabeelahmed
Board Regular
- Joined
- Jun 19, 2020
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Dear Friends, I am trying to do following where i need your help. Please help me to do below tasks
1- When I enter Customer number in sheet1 (Column"A") old PO number for the same customer with balance quantity from Sheet2(Column"B") should appear in Sheet1(Column"B)
2- When the quantity of old PO finished(Zero) then next PO number for the same customer id should should appear
3- I want PO balance for current PO in Sheet1(Column"B") once quantity issued as described in sheet1(Column"C")
Thanks & Regards,
Nabeel
1- When I enter Customer number in sheet1 (Column"A") old PO number for the same customer with balance quantity from Sheet2(Column"B") should appear in Sheet1(Column"B)
2- When the quantity of old PO finished(Zero) then next PO number for the same customer id should should appear
3- I want PO balance for current PO in Sheet1(Column"B") once quantity issued as described in sheet1(Column"C")
Thanks & Regards,
Nabeel