I have a database that will be constantly changing in length and for purposes of conditional data validation, I want to name hundreds, potentially thousands of ranges. I have made it far enough to get a table on a separate sheet with what I want the name of each range to be in column A and the actual range I want named in column B (see below for example - my current list has 500+ groups). I think I can manage a loop to run through the spreadsheet but I cannot figure out how to get it to name range D3:D4 as AAAA without manually typing it in. As I mentioned, I have 500+ ranges that will be changing in length monthly so this will not be a viable option. PLEASE HELP!
<tbody>
</tbody>
AAAA | 'Vistaarpaste'!D3:D4 |
AAAB | 'Vistaarpaste'!D5:D8 |
AAAC | 'Vistaarpaste'!D9:D9 |
<tbody>
</tbody>