Quickly Create 100+ Dynamic Named Ranges

Howdy,

I have 12 tables, one for each month.
I have 81 columns in each table (with same header titles across the 12 monthly tables).
The 81 columns are broken into 3 sections (17 columns, 32 and 32). Each "Section" automatically expands with the same amount of rows.


Section 1 (Table_Jan[[#Headers],[#Data],[Customers]:[Customer Penalty]]) or (BM7:CC81) = 17 columns, each column will have the same amount of rows (Currently 20 rows)

Section 2 (Table_Jan[[#Headers],[#Data],[BUs]:[BU PEN - Other]]) or (CD7:DI81)= 32 columns, each column will have the same amount of rows (Currently 4 rows)

Section 3 (Table_Jan[[#Headers],[#Data],[TYPEs]:[TYPE PEN - Other]]) or (DJ7:EO81)= 32 columns, each column will have the same amount of rows (Currently 19 rows)


If I were to manually input a dynamic named range for each column, and duplicate it for each of the 12 tables, I would be manually creating 972 dynamic named ranges...which sounds no fun at all.

Is there a way for me to grab each section of the table, rather than the individual columns (Thus making it 36 named ranges I would have to create)? Example of the formula I am using for each individual column is below.

=OFFSET(Table_Apr[[#Headers],[Customer Penalty]],1,0,COUNT(Table_Apr[Customer Penalty])+COUNTBLANK(Table_Apr[Customer Penalty]),1)

I am unsure as how to go about a VBA for my particular scenario and my data is already in a Table, so I am unsure about what you are suggesting by wrapping it in a table. The Table contains multiple cells with "#N/A" in them, and thus I am using dynamic named ranges to filter #N/A data out of my corresponding charts.

Any other ideas?

I made up this utility some time ago. Any use?