I cannot seem to find an answer to this on the internet or the forums.
I have numerous tables. I would like to select a specific table from a list of tables, and have that table returned in a cell next to the data validation drop down list.
For example, cell B4 contains a drop down list with the names contained in A4:A7. These names are tables as indicated by the name manager picture. I am hoping to selection a table name, and have that entire table be returned.
Is this possible without VBA? I will not be able to remember the name of all of my tables and entering =tablename into the cell is not cumbersome, but I am hoping to create a drop down list.
Many thanks.
I have numerous tables. I would like to select a specific table from a list of tables, and have that table returned in a cell next to the data validation drop down list.
For example, cell B4 contains a drop down list with the names contained in A4:A7. These names are tables as indicated by the name manager picture. I am hoping to selection a table name, and have that entire table be returned.
Is this possible without VBA? I will not be able to remember the name of all of my tables and entering =tablename into the cell is not cumbersome, but I am hoping to create a drop down list.
Many thanks.