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

amircse0711

New Member
Joined
Jul 22, 2019
Messages
25
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.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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
BCDEFG
3Target ColumnTarget RowsAddress
4Select$C$500C20$C$20
5100$C$100
6Link500$C$500
71000$C$1000
810000$C$10000
Sheet1
Cell Formulas
RangeFormula
G4=CONCATENATE("$"&$E$4&"$"&F4)
C6=HYPERLINK("#Sheet1!"&C4,"Link")
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top