|
|
#8
03-20-2016, 10:03 PM
|
|||
|
|||
Sorry, I happened to attach the wrong file.
The formula =INDIRECT("'"&$C$2&"'!RC",0) takes the value from the same cell (as where the formula resides) from the sheet specified in Main sheet!C2. The formula assumes that all sheets have the same structure. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Drop Down Menu to present Selected data in same sheet | awaisdotcom | Excel Programming | 1 | 04-04-2015 12:40 PM |
| Need help with drop-down menu please | cazclocker | Excel | 7 | 01-05-2015 04:07 PM |
| Methods to pull data from another sheet using drop down list | fajl | Excel | 0 | 07-19-2014 12:31 AM |
 HELP -- Drop Menu for Reoccuring Data??
|
cscaudle | Word | 1 | 03-02-2014 10:19 AM |
| Excel VBA: Pull data from web | tinfanide | Excel Programming | 0 | 12-09-2011 02:11 AM |
Windows 10 
Office 2016
Threaded Mode