Ah...that's nice. But it is dynamic. As far as I can tell, the worksheets here are never going to change until the US adds or deletes a state. Thus, once an index is generated with this, the macro can be deleted and the sheet saved once again as a normal spreadsheet.
I have to admit, my Excel VB is not all that great, but if someone could figure out how to have this populate another worksheet, that would save a lot of tedious hyperlinking.
Best of all would be to have it run non-native of either worksheet so that they don't have to be saved as macro-enabled.
|