Copy dynamic range (Unusual File Name Format)

[hecgroups]

Hello Again

Every day I have to make multiple provider statements of accounts which can be full year or partially period. I have a worksheet with named Statement (Final) with multiple statements with multiple years and multiple providers. I need to copy every period of every provider for every year and copy to a new worksheets within the same workbook. (Split Range until second blank row).

The script should copy data starting with header for every range until before 2nd blank row. Add a new worksheet with name of the first cell value after header in column D followed by period from first cell value after header in column C and last cell value after header in each range.
Example: ABC (Jan-Dec 2012) or JKL (Jun-Sep 2015)

Copy of manual workout for an expected output is attached for your reference.

[nilem]

Hi hecgroups,
try it

Please Login or Register  to view this content.

[hecgroups]

Hai Nilem,

Thanks for your response and solution.

But when I have tested on my original data, its is giving error as mentioned below.

Please Login or Register  to view this content.

I think the above error most probably due to exceeding the file name of the worksheets. I will be requesting to have below solution.

1. Make a worksheets with the provider name only.
2. Save that worksheets as workbook with the provider name with specified period in the same folder where the old workbook.

Can it be possible.

[hecgroups]

Topic marked as solve and reputation is added.