Originally Posted by scubadivingfool

This is what I was looking for, with a slight tweak though. Is there any way to have the cells in worksheet DTL 2 J6-20 auto populate into the E6-20 cells? When I change the info in the J6-20 cells nothing happens on the E 6-20 cells with the exception on changing of the names.

Also can you tell me how to edit the code you used? I have to place this into a pre-existing template. It needs to look exactly like the first attached image.

Thanks for all your hard work, very much appreciated

Originally Posted by wickedchew

Once you changed the names on column J, just change the name on E6 and the rest will follow.

The formula is quite hard to explain though... You can attach your template and I'll do it for you. ^_^

Originally Posted by scubadivingfool

OK, I have added the template. As you can tell, each day of the week are in each worksheet as well as a worksheet to do the timing inputs.

Thanks for all the help

Originally Posted by wickedchew

Here's your template.

I have included some instructions on how to use the template.

Originally Posted by scubadivingfool

This is exactly what I was looking for. Thanks

There are some errors however on the template. When I change the names of the people in the times worksheet, it is not changing on the weekday sheet

Thanks

Originally Posted by wickedchew

Have you tried changing the value in G10?

Each work day sheet has it's own corresponding column in the times worksheet.

Originally Posted by scubadivingfool

That I have. On Monday if I have George set to OPEN in the TIMES worksheet, on the Monday worksheet George get set to MID.

Also can you have the drop down selection digger please.

Thanks againtype