VBA Macro to copy 'schedules' in Excel.

[gonoje]

Hello Everyone,

I'm new here. It is nice meeting you all. I joined this forum because I need help with vba and seems you're of good help here.

What I'm trying to is a .vba macro to run a copy of my team agents' schedule day by day on a different screen.
There is an existing excel with different sheets, and the sheet I need to get is the one detailed day by day ('planning détaillé'), but displaying only the current day.
I have already done this part of the macro (attached).

Is there a way to do this with a vba macro?

I have uploaded the files for more help.

Thank you All.

Regards,
gonoje.

[gonoje]

Hello,

Any answer?