Quote:
Originally Posted by sumesh56
i have a spreadsheet. The ENTRY and EXIT should tally.
ENTRY----total of col A:D is in E2.
EXIT---- total of col G:J is in K2.
Cell K is formatted as E2=K2
cell K2 is formatted as the sum of G:J
when i enter a data wrongly in anywhere between the cells G:J a warning should come in col K2(of course after entering in all the four cells G:J).the idea is the number in entry should tally with that of the exit. is it possible?
the excel file is attached.
|
Hi,
It depends upon what is the type of validation you want. For example if you are only looking for a message. You can write a simple formula that compares the two total cells and return an error message. But this wouldn't stop the user from making the mistake.
If you want the user to not proceed until the two totals match you can use a VBA code and attach it to the Worksheet_Change event. Not sure if you can do this yourself. If you need my assistance for the VBA code, please let me know.
Thank You,
Prashant