• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to show data from predefined sets of tables by selecting name of table

H

Hellomoto

New Member
this question was inspired by "Making a Dynamic Dashboard in Excel [Part 2 of 4]". Assume scenario: I have 4 tables of data( A, B, C, and D), all the same size and type of data. e.g. 5x6 filled with text. Cell A2 is validated to list A,B,C, and D. Below A2 is a blank table with equal size and formatting (e.g. 5x6 ). I want to populate the empty table with the data from the selection in A2. (e.g. I select B, then the blank table is populated with data from table B). Similar to the transpose function except that I want to keep the orientation of the data the same.


Question is, how to do that? Thanks in advance.
 
Name your 4 areas

Change the Validation list to have the 4 named areas, Names

In the area you want to retrieve the data into use the formula

Select the whole area

Enter the array formula =indirect(Validation Cell)

Enter it as an Array Formula with Ctrl Shift Enter
 
You must log in or register to reply here.
Back
Top