File for work. please help!

Well, I can see why nobody else does this when you're out. The process really doesn't use Excel for any of Excel's capabilities; all it's doing is serving as an orderly place for you to keep manual track, as if you were just working with a large ledger sheet.

You know that, I realize, but what you need is an altogether different approach. And that could take a bit of time, going back and forth. Let me see what I can do quickly as a start. Unfortunately, I'm about to leave on a trip, so won't be able to do much. Perhaps some of the other helpers around these parts can jump in.

As noted, though, what you really will need to take advantage of Excel is a fundamental re-design.