i have a worksheet in which "ENTRY" and "EXIT" is entered. entry is from A3:D3 and its total comes in E3. exit comes in G3:J3 and its total comes in K3. now E3=k3.
when i enter data in any of the columns of exit and as a result when the total in col K3 does not tally with that of E3 there should be a error message. as per the vbcode in the attached excel file, it works for the row A3. i wanted to apply the code for the whole of the worksheet. how can i accomplish that? thanks.