EXCEL FORMULA for Merging Duplicate Data and Adding the Value

[shushu]

Hello. I need some help. I have this Excel workbook attached for inventory of medical supplies. Is there any formula alternative of consolidation that whenever the data in Sheet "Stock In" or "Stock out" would be entered, the duplicate data would be merged in another Sheet "Consolidated data' and its quantity would be automatically calculated.

QMEDICAL SUPPLIES.xlsx
originally, "stock out" "stock in" sheets are blank it will be filled-up only once there are stocks to be entered on each sheets respectively.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: EXCEL FORMULA for "Merge Duplicate Data and Sum the Value
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.