Forum Discussion
Input daily report tab into a running weekly tab
Hello Here is the outcome I'm trying to achieve for collecting production information. I input information at the end of day into an excel tab. One tab auto populates this information into a forma...
Could you please to give bit more details, in particular what on practice means "when I change the date". You have daily tab where the information is collected date by date, each column is the new date. Let say 365 columns per year.
Something like this?
In weekly tab you collect daily information for each week, so about 52 columns for each week in the year. Not clear which formulae you use and in general how do you aggerate weekly data - sum something, or count, or more complex operation.