Quote:
Originally Posted by ArviLaanemets
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.
|
What a very creative way to solve this problem. I am going to dig into looking into this example, but when I played with it, it was perfect.
I want to thank you and everyone for the help and recommendations. My knowledge has improved greatly with these responses.