Microsoft Office Forums - View Single Post - [Solved] pull data using drop down menu

Thread: [Solved] pull data using drop down menu

View Single Post

Old

03-20-2016, 10:03 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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.

Attached Files

example project_2.xlsx (36.5 KB, 13 views)

Reply With Quote