Workbook

[Liana]

I have a workbook that requires daily weekly & monthly totals, however each
day has a lot ofinfo so i have made a page for mon_ Friday with a weekly
summary sheet, now i am confused as to how to get monthly totals as I should
really have had daily 1st - 31st of the month but it all looks to cluttered
and will confuse the user.
Anyone got any ideas ( I suppose it will be hard to imagine without seeing
what I have here )

 

[E.Q.]

Hi,
First I'll wonder out loud if the application belongs in Access. But I know
that the database if very difficult to learn (I'm struggling through that
right now myself), so perhaps you can take advantage of some of the database
functions in Excel.
I'm wondering how big the daily sheets grows to be. If you can use one
sheet for your data entry you'll be able to extract the summary information
more easily. But even though Excel provides 65,000 + rows it doesn't seem to
work too well once it grows too large. (I have some simple files with about
18,000 rows and they're painfully slow - even though there's no formulas.
It's actually what inspired me to learn Access)
The AutoFilter feature can be used to filter out a single day's data.
Combine that with the subtotals function and you can get the daily totals.
You can also use array formulas or perhaps sumif or countif to extract data
from a long list.
I find that with lots of data in Excel, it often works well to have some
worksheets dedicated to data entry and storage then extract that data to
others worksheets to act as reports.
Would that be feasible or are you gathering a couple thousand entries each
day?
Peace.
EQC