I thank you all for your great and tireless effort to help the world.
I have been using the excel formula: =MIN(SUMIF(D:D,D3,F:F)-SUMIF(D$1:D2,D3,I$1:I2),E3) for some some time to calculate the total quantity of an item issued out of stock and as data increases in volume I notice that the computer slows down and therefore request for your help to create a VBA code to use so that it returns a value when entering data in the next empty row.
My excel table for data entry has headings as follows
Column D: Item Name
E: Quantity Received
F: Quantity Issued
G: Unit Cost
H: Value of Quatity Received ie, E * G
I: is Headed "Total Quantity out" of the Item in D
I am not a programmer but when tried to write the following code , before I could move to the next line a message box appeared with the following error notification;