PDA

View Full Version : Copy from one sheet to another



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 ???