Select Value from dropdown list and display the range of cells from the worksheet

[amircse0711]

Hello,

I want to create a dropdown list with some text and after the selection of the text with the submit button, I want to display the user to view the range of cell in the present worksheet.

To be more precise : Ex: the user select the the value C1, which is a table in the work sheet out of the 10 tables. The control or the view goes to the C1 table, which can be set by the range of cells in the code. So the drop down consist of C1,C2,C3 and the user select the choice and can have a easy view of the table.

Thank you for understanding the scenario and providing the solutions.

 

[RasGhul]

Is this what you need?

If I understand your goal correctly you can do this with a hyperlink formula, setup in this fashion you can enter target column & rows, the dv dropdown list of column G is E&F combined into the cell address.

Click on the "Link" hyperlink to snap the view to that cell address;

Book1
	B	C	D	E	F	G
3				Target Column	Target Rows	Address
4	Select	$C$500		C	20	$C$20
5					100	$C$100
6		Link			500	$C$500
7					1000	$C$1000
8					10000	$C$10000
Sheet1

Cell Formulas
Range	Formula
G4	=CONCATENATE("$"&$E$4&"$"&F4)
C6	=HYPERLINK("#Sheet1!"&C4,"Link")

 

[amircse0711]

Thanks a lot RasGhul for an easy and effective solution.

 

[RasGhul]

You're welcome.