Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 3 Tables, i.e. T1, T2 and T3 defined as cell ranges with the same
number of rows/columns, different cell values. I want the user to select a table, then select a row value and column value. I use the row and column values to create indexes into the table and retrieve a cell value. I use a cell Data Validation with a list value of T1, T2 and T3 for the user to select a table (and select the row and column values). How do I convert the Data Validation string value of T1, T2 or T3 to the appropriate table reference? Once I have the table reference, I can use the row/column values to index the table. Please submit any better solutions you may have. thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) | |||
table | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |