excel database management

excel database management

Working at my excel file macros

there is titles with sub titles in a  few titles lines in excel (2)
i programmed this in a static way
now i want to reprogramm it with a recursive sub to generate sub titles everytimes a new array is in an array

this way the excel table will be generated with titles and sub titles, infinitly (recursiveness)
this sub have to be done object so it can be used by any part of my programming

including displaying other tables

ideally, one objecty should contain all arrays that will generate all titles and sub titles recursively

i also have to think about futur use, like editing thoses table and adressing the right column name while doing it even though there will be sub titles for evey columns, only the last sub title will be the column name used to access the data, the rest of the main titles will be there only for appearence and clarity