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