pull data using drop down menu

nfsmith · #1 03-20-2016, 06:07 PM

works like what you have done, I have attached my example on last one not sure if your able to use that. are you able to share the steps I need to do

xor · #2 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