thejmiller
New Member
- Joined
- Apr 26, 2013
- Messages
- 3
I am pulling raw survey data in to Sheet1 and want to write a code make a dynamic table in Sheet 2 so that it only includes the columns that are relevant to the respondent and hides all of the other columns.
In the survey the respondents identified the industry that they operate in. This data appears in Sheet1 of my workbook and each industry has its own column (column I-Q). Sheet1 also includes a unique identifier in column A.
In Sheet2 I have built a table that includes columns for the average of of all respondents in Sheet2 Columns B-J.
What I want to do, is run a lookup based on the unique identifier in Sheet1 Column A to do the hiding of irrelevant columns.
Anyone know a good place to start with this? Thanks.
In the survey the respondents identified the industry that they operate in. This data appears in Sheet1 of my workbook and each industry has its own column (column I-Q). Sheet1 also includes a unique identifier in column A.
In Sheet2 I have built a table that includes columns for the average of of all respondents in Sheet2 Columns B-J.
What I want to do, is run a lookup based on the unique identifier in Sheet1 Column A to do the hiding of irrelevant columns.
Anyone know a good place to start with this? Thanks.
