Automatically transfer data from a monthly duty roster table (3-shift system/7 days) to a weekly table.

Hello,

Unfortunately, I'm not very familiar with Excel's VBA code. I'd like to automate the creation of the weekly schedule for about 50 people, based on the monthly schedule where the respective shifts are already defined.

Is it possible to program something like this with VBA code? And could you help me identify the specific commands I need to learn to implement this?

Further information about the original table:

The structure is as follows:

1st row: the date

1st column: the employee names, followed by the shift for each date.