Another example which uses CHOOSE() to select Table.
On sheet States I entered full list of states, but as I didn't add sheets and Tables for all 50 states (otherwise I couldn't create nRepRange), I added there a table tTest with 2 states listed too, and used it as base for dynamic ranges. You have to edit them when you want to use the full list of states.
|