Hello,
I've encountered a problem with a project i'm working on. So far I couldn't find anyone with a similar problem so here it is.
In one of my worksheets I have a table containing 1's and 0's, which are generated using a v-lookup.
Horizontal I have the names of companies and vertical I have students names.
Because another program is reading this data, I have to assign a name to the table so the other program can read it (only the 1's and 0's, not the names).
However, my model should be able to ad/delete names and companies, i.e.; every time I change the dimensions of the table, I have to change the range of the name definition as well manually.
Because I have up to 12 of these (huge) tables, I was wondering if this could be done using a formula.
So in short; if I add/delete rows/columns to a table, can the name of the table change dynamically with its dimensions?
Bookmarks