VBA - Date Range - Fill in the gap dates/paste horizontally in different sheet

[RyanMcL20]

Hello!

I'm new to VBA and am trying to come up with a code for the following purpose. I'll do my best to explain myself.
In this picture below in row 4 "Project Duration (x/xx/xxxx) To (x/xx/xxxx), the TWO highlighted cells (B4 & C4) make up the date range I need. This excel file is meant to be a template for others to fill in. With that being said there will obviously be different date ranges input into this every time. I have a form control button to the right of the highlighted cells with the intentions of making that button produce the desired outcome I want.

When the button is pressed, I want the two highlighted cells that make up the date range to fill in the gaps between months and paste the entire sequence to a different sheet, horizontally. But I don't want it to list everyday. I need it to list.. Example: Oct-2021, Nov-2021, Dec-2021, Jan-2022..etc
Each one of these months starting with Oct-2021 through to Aug-2022 needs to be pasted horizontally in it's own individual cell on another sheet. The sheet I need it pasted in is named "PGB" the sheet# is Sheet7 and the cell is D3.

Any guidance or help would be greatly appreciated. I'm stumped.

Thank you.
-Ryan

 

[RyanMcL20]

Have tried a few different ideas but can't come up with something solid as of yet.