weekly report
I have created a file to report data weekly. Sheet 1 is the report, Sheet 2
is the data. Sheet 2 columns are Date, Day, Data1, Data2, Data3 for a total of 7 columns. I have entered the year of dates in the Date column and the Day of the week in the Day column on sheet 2. Sheet 1 has 3 sections. Section 1 is for the daily information on a week to week basis. Section 2 is a summary of the weeks of the month and Section 3 is a monthly summary for the year. I'm able to populate the monthy summary with formulas that refer to sheet 2. How can I have sections 1 & 2 read sheet 2 and automatically pick up the daily and weekly information on a weekly basis? |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com