hello
I have two files every file contain two sheets(import & export and my file destination is inventory I would bring data based on select l2 then sum and subtract among e f,g,h, i put the formula in col I to understand it for more explanation inside file
attached file
inv.rar
note: also issue this post in another forum no answer so far
copy data from multiple workbook and sum & subtracting among columns - OzGrid Free Excel/VBA Help Forum
I have two files every file contain two sheets(import & export and my file destination is inventory I would bring data based on select l2 then sum and subtract among e f,g,h, i put the formula in col I to understand it for more explanation inside file
attached file
inv.rar
note: also issue this post in another forum no answer so far
copy data from multiple workbook and sum & subtracting among columns - OzGrid Free Excel/VBA Help Forum