LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Alan
 
Posts: n/a
Default Table References

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing errors from a Pivot table Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 03:15 PM
table dow Excel Discussion (Misc queries) 0 January 12th 05 02:25 PM
table dow Excel Worksheet Functions 0 January 11th 05 05:17 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"