maghari
04-06-2020, 02:31 AM
hi i ruly apprecaite if anybody can help me i issue this post in last time
https://www.ozgrid.com/forum/index.php?thread/1227156-sum-subtract-array-of-columns-among-multiple-sheets/
in the beginning the code works but when i repeat running macro every time it gives me wrong value in column d in sheet6 to understand how it works the code i asked summing and subtracting among multiple sheets in the same column (d) and show the results in sheet6 maybe it's not enough to understand you can check my file and compare values of column (d) for instance code : aa1=250+120-50-50+50 it supposes to equal 320it only happens right in the firs time which run the macro i hope this help
https://www.ozgrid.com/forum/index.php?thread/1227156-sum-subtract-array-of-columns-among-multiple-sheets/
in the beginning the code works but when i repeat running macro every time it gives me wrong value in column d in sheet6 to understand how it works the code i asked summing and subtracting among multiple sheets in the same column (d) and show the results in sheet6 maybe it's not enough to understand you can check my file and compare values of column (d) for instance code : aa1=250+120-50-50+50 it supposes to equal 320it only happens right in the firs time which run the macro i hope this help