Anbuselvam K
Member
Dear Excel Genius
In the attached excel worksheet, I have PO ENTRY and SALES ENTRY Worksheets.
PO Entry sheet has PO Number and it is quantity. The sales Entry sheet has the PO number and the sales quantity.
I need a pop-up error alert when the sales entry quantity exceeds the PO quantity.
For example,
PO Number ST07/1697 has 100kg of quantity, But the sales 125kg. The sales exceed the PO. So it has to notify the user that this sale exceeds the respective PO Number.
As with ST09/1670, PO Qty is 1000kg but the sales are 1100kg.
I need some notification or pop-up alert when the user enters the sales more than the PO.
I am expecting your valuable reply.
In the attached excel worksheet, I have PO ENTRY and SALES ENTRY Worksheets.
PO Entry sheet has PO Number and it is quantity. The sales Entry sheet has the PO number and the sales quantity.
I need a pop-up error alert when the sales entry quantity exceeds the PO quantity.
For example,
PO Number ST07/1697 has 100kg of quantity, But the sales 125kg. The sales exceed the PO. So it has to notify the user that this sale exceeds the respective PO Number.
As with ST09/1670, PO Qty is 1000kg but the sales are 1100kg.
I need some notification or pop-up alert when the user enters the sales more than the PO.
I am expecting your valuable reply.