Hey everybody, I need some assistance. I've been trying to come up with a command button to be able to add / subtract inventory from the current inventory.
I have a rough example of some random data below. I'm looking to essentially for a function to allow Range C = Range C + Range D - Range E. I was able to do it for a single line item, but i have a parts table of over 2000 items, and have been having a hard time with making something for a running total.
After either adding/subtracting inventory, i would like to use the clear contents function to clear all the items in Range D and Range E. I'm not sure if I can combine both the addition and subtraction into the same command button. If not, I can create two command buttons, one for Qty In. and one for Qty Out. Any help would be appreciated.
I have a rough example of some random data below. I'm looking to essentially for a function to allow Range C = Range C + Range D - Range E. I was able to do it for a single line item, but i have a parts table of over 2000 items, and have been having a hard time with making something for a running total.
After either adding/subtracting inventory, i would like to use the clear contents function to clear all the items in Range D and Range E. I'm not sure if I can combine both the addition and subtraction into the same command button. If not, I can create two command buttons, one for Qty In. and one for Qty Out. Any help would be appreciated.