check total

    I have to check the work of my fellow associates everytime.


    Please see the attached sheet and is there any way by which the VBA calculates the total for columns H and K and if there is a mistake it corrects the mistake.


    The list is endless and keeps on growing.


    Mistakes should be pointed in red, but the red color should not be saved when saving the excel sheet, but the mistakes corrected should be saved.

    Re: check total


    It would seem to be a rare thing where the two totals did match. What would be the correction? Both columns compute values differently so I don't know why the totals would be the same. I guess you can show a version where it does what you wanted.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login