Excel Macro: Fill Blank Cells with Respect to No. of Rows

Hi ExcelForum Experts,

Please see attached workbook as reference.

I am wondering if someone could help me with the flexible codes which will only capture the data in a certain table. I have a monthly data with fluctuating number of rows and I am having a hard time creating a macro codes that will only select range of cells based on the number of rows of column F (please see attached workbook). The macro code that I have recorded is only applicable to the attached workbook with "46" number of rows. If I have "75" number of rows next month and "105" number of rows or more on the following months, the said macro codes will not work unless I adjust the range.

Let me know should you need additional details. Have a nice day ahead!

Warmest regards,
Arnel