I am certainly no expert on excel but do tinker with it. Could you put your daily info just on one worksheet? That might make it easier to play it. The other possibility is having a look at using the visual basic editor via the macro menu, but unless you know something about it; it appears a mean learning curve.
Googling my excel problems I have come up with some interesting sites.
Roaminoz mind if I call on you for help on excel if needed in future?