changing sheet content in excel

I want to have 11 spreadsheets and have, on spreadsheet one the content of spreadsheet 2 from sunday to saturday of that week, then show sheet 3 the following week, then sheet 4 the next week and so on.  Is this possible based on dates and if so how would you do it?
Dier02Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
OK.

In this case, follow the golden rule: raw data on one sheet, reporting on different sheets.

In this case, your weekly/current week sheet is a report. If you structure your raw data sheet correctly, this will be a breeze. Post a data sample with a few weeks worth of data so we can work with your layout to provide a solution.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

it would be easier to have the content all in one sheet and then display the current week on another sheet.

What are you trying to achieve?

cheers, teylyn
0
 
Dier02Author Commented:
Essentially - I want to be able to open the excel workbook and have the relevant weeks work displayed on worksheet 1.
0
 
Dier02Author Commented:
Followed your path and it worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.