Using one daily sheet to fill in a weekly total

%3CLINGO-SUB%20id%3D%22lingo-sub-3073473%22%20slang%3D%22en-US%22%3EUsing%20one%20daily%20sheet%20to%20fill%20in%20a%20weekly%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073473%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20have%20one%20data%20entry%20worksheet%20for%20Monday-Sunday%20that%20can%20populate%20the%20daily%20amounts%20to%20a%20weekly%20sheet.%20The%20kicker%20is%2C%20I%20dont%20want%20to%20have%20multiple%20Monday-Sunday%20sheets.%20I%20need%20the%20data%20to%20automatically%20go%20to%20the%20next%20week.%20So%20if%20I%20put%20a%20value%20in%20the%20data%20entry%20sheet%20for%20Sunday%20it%20would%20go%20Sunday%20the%201st.%20The%20next%20week%20I%20want%20to%20to%20use%20the%20same%20data%20entry%20sheet%20for%20Sunday%26nbsp%3B%20but%20I%20want%20the%20values%20to%20go%20to%20Sunday%20the%208th.%20Is%20this%20possible%3F%20I%20am%20using%20Microsoft%20365%202018%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 the data to automatically go to the next week. So if I put a value in the data entry sheet for Sunday it would go Sunday the 1st. The next week I want to to use the same data entry sheet for Sunday  but I want the values to go to Sunday the 8th. Is this possible? I am using Microsoft 365 2018

 

Thanks for the help!

Steve

1 Reply

@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.