I have a spreadsheet that is being used to update a project list on a weekly basis. Every week, the header is changed from Week 1 to Week 2 to Week 3 and so on until the end of the year. I want to be able to take data from each week (multiple cells) and automatically transfer this information to a new sheet whenever the number of the week in the "Week #" cell is changed. I would then like the data I entered for that week to clear out on tab 1 and start clean on for the next week. For example, week 6 information stays in there but whenever I type week 7, this data transfers from sheet 1 to the new sheet that is automatically created. This way, at the end of the year I will have a tab for each week so if I need to go back and review something I can just click on that week's tab.
Automatically move data to a new sheet based on a value