MontySharpei
11-03-2011, 11:28 AM
Good evening,
Could anyone please advise me ?
(Two sheets attached)
I want to send sheet 1 to tream leaders to fill out for the next two weeks and return it.
Upon its return I want to open the Master Sheet
where by some method I want it to match the team from down column B to that from the entry in Sheet 1, cell A1 ; match the dates and copy the entries across for the 2 weeks ??
Could this be done so I have 1 sheet (Master) that I can see all teams ???
Could anyone please advise me ?
(Two sheets attached)
I want to send sheet 1 to tream leaders to fill out for the next two weeks and return it.
Upon its return I want to open the Master Sheet
where by some method I want it to match the team from down column B to that from the entry in Sheet 1, cell A1 ; match the dates and copy the entries across for the 2 weeks ??
Could this be done so I have 1 sheet (Master) that I can see all teams ???