Forum Discussion
Using Excel Spreadsheet to log calls by month, where each tab is a day of the month (M-F)
Let's back up a bit.
Having a workbook with separate tabs for every day sounds like a bad design right off the bat. It works for the human being in us--we like to see each day on its own fresh sheet, and that's how we'd do it if we were keeping a log of calls on paper. But you're wanting to use the computer in this case, and what you describe actually interferes with some of what Excel might be able to do (e.g., consolidating entries by category, summarizing numbers of calls by category). If you're planning on doing that, or anything like it, it would make more sense to have all calls logged on a single sheet, with the date noted in the first column. From that single database it would be very easy to extract a given day's calls, but also to do some of those summary reports I allude to with my question.
If you're not planning on summary reports along those lines, if this is "just a log," why are you using Excel in the first place? Because it has neat rows and columns? You might find Word (the table format in Word) to be more flexible, and you could start a new day with a new page or a new document.....