Hi guys i have a roster that is on a single worksheet.
What i want to do is when I change a name into a particular shift it then takes that shift and copies the shift onto another worksheet.

So when its done each employee will have a worksheet with just his shifts on it, there are only 5 employee's atm, so instead of them having to go through every day to see what each day has they can just click on their own name and get a roster that has the week setup for them.

Does this make sense? if not I can post the roster to show you what it is I want to accomplish.

many thanks