insert three columns and bring the values based on matching with two workbooks

hello
I have two workbooks report1,2 contains data should match in COL B,C,D with file OUTPUT Also IN COL B,C,D then inserting three columns and brings the values in COL sales and purchase and calculate in COL QTY i need show the formula in COL QTY and it should summing the values from files each COL SALES AND PURCHASE and add to file OUTPUT and if there are brands are existed in files and not existed in file output should add to file output as highlighted by yellow but when add them should match col A in files with COL A in file output and add it before total
note : the files in the same folder and may be increase the files also the data in output is increasable in rows I mean in COL A,B,C,D
I put the result in sheet after and the original data in sheet before but should show the result in sheet1 , and every time run the macro should insert three columns with same borders and formatting also formulas .
if this is not clear please inform me

I thought post#3 is clear when I put the formula in last column in J the idea is when insert a new three columns the last column which calculate the values depends on precede the last column as in sheet result1 last column which calculate the values is G and the precede last column is COL G then when calculate and show the values in COL J= 32+65-25 =77 and if I insert a new three columns as in sheet result2 last column which calculate the values is M and the precede last column is COL J then when calculate and show the values in COL M= 77+65-20 =77 the same thing whit the others rows except TOATL row and every time insert a new three columns the formula should be the precede last column + a new purchase - a new sales
I hope this help please check two result result1,2

it shows the total for purchases and sales and qty(stock) for each category for instance category for OIL-208L it shows how calculate Total values the purchases and sales and qty in row total , it calculates for each category separately and I've found some cells when I sum them , they're not within the formula , I fixed it and updated the file

You must review the workbook for yourself if nobody answer.

No one want to do such a "GUESS" work and no one but only you know the details of what you are trying to do.

Please Login or Register  to view this content.