Forum Discussion
Problem with excel data
Since by your own admission you need help, I hope you can accept some help that disagrees with some of your opening premises. For example, you seem to think that one big sheet would be a terrible idea, but I'm going to assure you that one big sheet probably would be the best way to handle this, letting Excel take care of splitting it into separate days for summarizing or reporting or reviewing or whatever.
What you're describing is taking a "do it on paper ledger sheets" mentality or framework and transferring it to the computer. But when you do that you're not letting the computer do what it does best.
So, if you're willing to reconsider some of your opening lines, let's begin by asking you to back up and be more descriptive regarding all of this data that you need to collect and enter many times a day.
- What is the data that could fall under the category of "Input"? Please be as complete and specific as would be needed to get an understanding of "the big picture"
- What needs to happen to that data once collected? Do you have to summarize it for reporting purposes? Something else? Said another way, what's the expected or required "Output"?