#1
|
|||
|
|||
Recommendation on different worksheets
I am using the index function on a lot of data. To make it quicker I have split off my data into multiple worksheets. I have a drop down list and the user would select a state. Each worksheet is a state.
I have no problem of when a user selects a state that it somehow copies that data from the correct worksheet and then the index function could run on the current sheet. Maybe you can somehow index directly the correct worksheet after it is selected. There maybe another way to solve this issue. If you have an idea, I am willing to run tests. I am attaching a basic example file and B1 cell is the pull down. Once the user selects a state, I would like it to get the information from the correct worksheet (to make it easy the values in the drop down = the worksheets name). Thank you so much for your recommendation. Jeff Unruh |
#2
|
|||
|
|||
Maybe like the attached
|
#3
|
||||
|
||||
@radicalrom
Please read the last post at thread https://www.msofficeforums.com/excel...tml#post136994 Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
That is very cool about the indirect function. I am going read up on how it works, but this is great. Thank you. |
#6
|
|||
|
|||
Quote:
I want to thank you and everyone for the help and recommendations. My knowledge has improved greatly with these responses. |
Tags |
index, recommendation, worksheet |
Thread Tools | |
Display Modes | |
|
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 |