RaviSikaria
New Member
I have a simple excel, wherein, the the columns are: (A) item name, (B) quantity bought (positive value) or quantity sold (negative value) and (C) Price of the particular transaction is mentioned. Nearly 200 items are being considered. I want an excel program, which would provide me as output, the quantity of the individual items and price at which the inventory is there. This shall not take into consideration any profits/loss made earlier.
For eg, Let's say, item A was bought 10 times (total qty: 965) and sold for 5 times (total qty: 389). So the program shall give me the inventory available and the average price at which the balance inventory of 576 units was bought, without considering the profits/loss made in 389 quantity sold.
Request your help for the VBA solution.
For eg, Let's say, item A was bought 10 times (total qty: 965) and sold for 5 times (total qty: 389). So the program shall give me the inventory available and the average price at which the balance inventory of 576 units was bought, without considering the profits/loss made in 389 quantity sold.
Request your help for the VBA solution.