Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Weekly Report (Formatting) | Excel Discussion (Misc queries) | |||
how do i set up a weekly sale report in excel? | Setting up and Configuration of Excel | |||
HOW TO MAKE WEEKLY,MONTHLY,ANNUALLY INCOME AND EXPENSE REPORT | Excel Discussion (Misc queries) | |||
Incoming/Outgoing per person per day? & Create weekly report | Excel Discussion (Misc queries) | |||
with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions |