rspeulstra
New Member
- Joined
- Mar 14, 2014
- Messages
- 16
Hello,
I would like to know if the following is possible:
I have an excel sheet with X different tables, lets say X = 3
A) Is it possible to make a dropdown list (validation list) which shows all the available tables in an excel workbook? Preferable dynamic, so if the amount of tables grows, the dropdown list with tables should grow accordingly...
B) After that, is it possible to automatically click on the selected table so it will jump to this table? I know how to do this with sheets (using the hyperlink fuction) but not with tables.
I would prefer a solution without using VBA, unless this is not possible.
I would like to know if the following is possible:
I have an excel sheet with X different tables, lets say X = 3
A) Is it possible to make a dropdown list (validation list) which shows all the available tables in an excel workbook? Preferable dynamic, so if the amount of tables grows, the dropdown list with tables should grow accordingly...
B) After that, is it possible to automatically click on the selected table so it will jump to this table? I know how to do this with sheets (using the hyperlink fuction) but not with tables.
I would prefer a solution without using VBA, unless this is not possible.
