get one week at a time

[mduntley]

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

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>

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

 

[onlyadrafter]

Hello,

in B3 on your destination sheet, enter this formula

=INDEX(Sheet1!3:3,0,MATCH(B$2,Sheet1!$2:$2,0))

and copy down and across as far as required.

Is this of any use?

 

[mduntley]

Thank you very much