Hey Guys,

So I have a file which updates everyday and adds number to month to date file.
Now, I want to use that month to date (MTD) file and split it into 4 weeks.
starting from 1st to 7th and so On.
I want the particular column and row to read MTD file only till 7th and then a new column to start reading it from 8th and stop on 15th and so on.

Can this be done?

Thanks.