weekly report

M

mbparks

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Weekly Report 2
Need some PWA help 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Section and Page numbering 0
adding daily totals to weekly totals 3

Top