Auto update cells in a table, based on the content of another table...

[Darth269]

So, and I'm uploading an sheet as an example... I've got a table, which is used to arrange activities over a week, for several people.

it uses data validation drop down lists.

As these options are changed, I'd like the tables below (one for each type of activity) to populate the right day, with the right names (ok, so this doesn't make much sense, but I hope looking at the sheets should make it clearer).

I don't know if it would be better to update the first table, and then use a button activate macro to move the names to the right place, but the above method would be preferable to me if it's possible/not ridiculously over complicating things.

Turn Sheet.xls

Many thanks in advance for any advice hints or suggestions!

[Darth269]

Are we allowed an occasional topic bump on these forums? I hope so... as I guess thats whats this is...

[arlu1201]

What data should populate under Day and under Notes?

[Darth269]

Sorry I took so long to post here, but i re-wrote the script, its now fine. Thanks