Hi all,
Please help me about this situtation. Now, I have much orders which are have some kind of goods is the same. It's on the data_need_find sheet.
The inventory have the total data = data_source sheet.
And the question is, how I could make a macro to minus decesing the quantity of each kind of goods by each order, like these attachment.
Thank you so much!
p.s: cuz, I cant attach, so please check the link to excel file: https://drive.google.com/open?id=1gbAWqKitF_P-eFlaXhw3pzzXQZFPnsMh
Please help me about this situtation. Now, I have much orders which are have some kind of goods is the same. It's on the data_need_find sheet.
The inventory have the total data = data_source sheet.
And the question is, how I could make a macro to minus decesing the quantity of each kind of goods by each order, like these attachment.
Thank you so much!
p.s: cuz, I cant attach, so please check the link to excel file: https://drive.google.com/open?id=1gbAWqKitF_P-eFlaXhw3pzzXQZFPnsMh