Roy,
Thank you I appreciate your help. I had initially thought about doing it this way to keep things simple. My only reservation about this approach is that it could be a little bit tedious scrolling through the drop-down for each line in the coordination tasks worksheet. I like the idea of being able to scroll through the SD Tasks worksheet and select the tasks the pertain to the project. This way I only have to scroll through the tasks once and I don't accidentally create duplicate tasks in the coordination task worksheet.
Thanks,