Hello. At work we are using a schedule on a excel. We have one sheet that has the year. But I want to create another sheet that only has one week listed when I put in the first day of the week. This is what I mean:
Note, this is exactly what is on the sheet, beside the name and the time. I am more focusing on getting the data from a11-a40. column A will be copy and paste in, so i only need the formula for coulmn B to F
Here is the master sheet
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>So on a different sheet, if I put in 6/7/15 in b2, i want the sheet to give me the whole column 6/7/15 from the master sheet. So I can then put 6/8/15 in c2 and get the whole column in C. I will then apply this to d2 to h2. If I change b2 to 9/9/15, i want to get the column of 9/9/15.
If you dont understand, then I can explain more
Note, this is exactly what is on the sheet, beside the name and the time. I am more focusing on getting the data from a11-a40. column A will be copy and paste in, so i only need the formula for coulmn B to F
Here is the master sheet
staff name | Sun | Mon |
6/7/15 | 6/8/15 | |
a3 | ||
a4 | ||
a5 | ||
a6 | ||
a7 | ||
a8 | ||
a9 | ||
a10 | ||
Group 1 | ||
a12 | 9a-9p | 9a-9p |
a13 | 8p-4a | 8p-4a |
a14 | 8a-4p | 8a-4p |
a15 | 5p-9p | 5p-9p |
a16 | 5p-5a | 5p-5a |
Group 2 | ||
a19 | 9a-9p | 9a-9p |
a20 | 8p-4a | 8p-4a |
a21 | 8a-4p | 8a-4p |
a22 | 5p-5a | PTO |
Group 3 | ||
a25 | 6a-6p | 6p-6a |
a26 | 6p-6a | 6a-6p |
a27 | 6p-6a | 6p-6a |
Group 4 | ||
a30 | 6p-6a | 6a-6p |
a31 | 6a-6p | 6p-6a |
a32 | 6p-6a | 6p-6a |
a33 | 4a-4p | 4a-4p |
a34 | 4p-4a | 4p-4a |
Group 5 | ||
a37 | 6p-6a | 6a-6p |
a38 | 8a-4p | 8a-4p |
a39 | 6p-6a | |
a40 | 6A-6P | 6a-6p |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
If you dont understand, then I can explain more