Automatic selection based on a choice

[tigfur]

Hello!

I plan to make a time Schedule for work hours, i have made for you to see it clearer an example

in each 30 minutes there are 6 (i might make 7 but that shouldnt matter) cells containing information that might or might not be filled, depending where they are in the timetable

those 7 cells are gonna be copied all over the thing, the insides will be invisible if not filled, unlike this test file.

above the time table there are buttons with workers name, with a macro changing the color of users selection (thus easily assigning a certain worker to that area and seeing which ones are busy)

next to "type of work" there is a list where you can choose how long the work is gonna take in hours

my idea is right after one chooses the time, an automatic selection selects the right cells representing the time in the timetable so the user wouldnt have to do it each time and worry about doing it right, they would only have to click the right color

can this be done easily (dont forget each row and collumn has more of these and they should only do this once, after changing the value, it has to be "copyable"