Vba code for qty data update

[harinsh]

Hi Team,

I am looking vba code in order to get desire output. I have several columns which contains product details, there is column called "Qty" we get request from customer and will order the goods based on available qty in our store. If available in store then will get it otherwise will get it from different supplier.

The interesting part is then each product has different qtys and products may repeat in the excel lines items the main qty column should automatically change when we identified the available stock in the store.

For example:
Require product details as below.
Product A 20
Product B 10
Product c 15
Product B 05

In Store
Product A 10
Product B 12

Here if you can see for Product B we need 10 qty however in store we have 12 so, we have 2 excess in first instance so, I need status correspondent to product B is 12-10 = 2.
Later, if move to same product in further line again need 05 qty but we have only 2 hence, correspondent status should be -3.

Here need to dynamically qty column should change as per requirement and should show the left qtys.

Hope can anyone should assist me with above requirement.

Thank you