This should be relatively easy for a knowledgable coder. I have a cover sheet which I report balances based on several worksheets. I would like to run a macro that can simply check the totals against the cover sheet totals to make sure the numbers match in the specified cell. That way, I avoid any human error. Can anyone suggest a simple way? Appreciate your help.
For example, in sheet1, I have a balance total in say cell D10. D10 should match a total in sheet3 in say K7. If it doesnt match, I'd like to have the difference show in E10. The cells are arbitrary. Just looking for a general form that I can adjust according to my layout. Thank You!
Bookmarks