I have 5 tabs within a workbook. The 1st tab captures 28 days of data. The next 4 tabs are meant to separate the 28 days of data into weeks; separated by 4 weeks and therefore 4 weekly tabs.
What I want to do is have the 4 weekly tabs auto-fill with the data from the 1st tab. So "Week 1" would have the first 7 days of information collected from Tab 1, and "Week 2" would have the next 7 days of information collected from Tab 1, and so on and so on.
So basically, can I create a formula that automatically fills data into the weekly tabs that is already entered into Tab 1, based on data range of 7 days for each weekly tab?
I have very limited experienced with formulas, please bear with me.
Bookmarks