Dier02
asked on
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?
ASKER
Essentially - I want to be able to open the excel workbook and have the relevant weeks work displayed on worksheet 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Followed your path and it worked.
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