Recommendation on different worksheets

ArviLaanemets · #1 01-06-2019, 04:34 AM

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.

radicalrom · #2 01-06-2019, 05:58 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Several Worksheets into one master	caz46	Excel Programming	2	05-11-2018 11:13 PM
Recommendation for good powerpointer clicker or remote app	s_turner	PowerPoint	1	07-21-2014 06:53 PM
Need weekly Work log template recommendation	Shazamy	Excel	2	10-04-2013 10:50 AM
Interactive worksheets on the web	beingbobbyorr	Excel	1	08-22-2011 05:32 AM
File compression recommendation	bb80	Office	1	08-13-2009 10:58 AM