hi experts
I have two sheets DATA and before . the sheet after just to understand what I want . the result should be in sheet before . so what I want match data between two sheets in COL B,C ,D for each item in COL A the values should be in last columns IMPORT, EXPORT because every time I insert theses columns so when if new data are existed in sheet data but not existed in sheet before then add to before TOTAL row as highlighted by red and if there are existed into two sheets then should pull the values and put in last columns IMPORT , EXPORT as highlighted by blue
note: when insert new row should not affect for the borders and formulas . I put the result in sheet after
Bookmarks