Forum Discussion
Using one daily sheet to fill in a weekly total
Hello! I am trying to have one data entry worksheet for Monday-Sunday that can populate the daily amounts to a weekly sheet. The kicker is, I dont want to have multiple Monday-Sunday sheets. I need ...
Svargo Use Excels built-in capabilities to summarise the data, however you want. For instance with one or more pivot tables.
If you add real dates to each entry, you don't have to say it's a Sunday. Excel knows this and you can have it display the name of the day, which you can then use for filtering or summarising.
All it requires is a Data Refresh All, after you have entered more data. The attached workbook is just an example of what's possible.