I need a way to dynamically populate cells based on a value that is selected in one cell.
Example:
Column A and B is my data set.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:|
3 |TeamB| Michael Smith|
4 |TeamA| John Williams|
5 |TeamB| Susan|
6 |TeamA| Jack|
Cell D1 is a drop down list with selection options ‘Team A’ and ‘Team B’
I want to dynamically populate the values in Column D (Cell D2, D3 etc) based on the value selected in D1.
So if D1= Team A then cells D2, D3 and D4 should be populated with names John Doe, John Williams and Jack.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:| John Doe
3 |TeamB| Michael Smith| <Blank>| John Williams
4 |TeamA| John Williams| <Blank>| Jack
5 |TeamB| Susan|
6 |TeamA| Jack|
if D1 = Team B then cells D2 and D3 should be populated with values Michael Smith and Susan. D3 will be blank.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:| Michael Smith
3 |TeamB| Michael Smith| <Blank>| Susan
4 |TeamA| John Williams|
5 |TeamB| Susan|
6 |TeamA| Jack|
It’s basically like creating a pivot table like functionality manually without using the default pivot table. The above is just a basic example I have a data table of 155 rows and 30 columns with lots of information and I need to arrange it in this way in order to create a proper chart. Pivot chart isn’t exactly helping me much.
Thank you
PS: Sorry about the formatting of the table. it does not display properly. Each column is separated by '|'. the numbers at the beginning of each line represent the row number. Hope it helps to understand the data set.
Example:
Column A and B is my data set.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:|
3 |TeamB| Michael Smith|
4 |TeamA| John Williams|
5 |TeamB| Susan|
6 |TeamA| Jack|
Cell D1 is a drop down list with selection options ‘Team A’ and ‘Team B’
I want to dynamically populate the values in Column D (Cell D2, D3 etc) based on the value selected in D1.
So if D1= Team A then cells D2, D3 and D4 should be populated with names John Doe, John Williams and Jack.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:| John Doe
3 |TeamB| Michael Smith| <Blank>| John Williams
4 |TeamA| John Williams| <Blank>| Jack
5 |TeamB| Susan|
6 |TeamA| Jack|
if D1 = Team B then cells D2 and D3 should be populated with values Michael Smith and Susan. D3 will be blank.
Column A| Column B| Column C| Column D
1 |Team| Resource| Select Team| <Drop Down>
2 |TeamA| John Doe| Resources:| Michael Smith
3 |TeamB| Michael Smith| <Blank>| Susan
4 |TeamA| John Williams|
5 |TeamB| Susan|
6 |TeamA| Jack|
It’s basically like creating a pivot table like functionality manually without using the default pivot table. The above is just a basic example I have a data table of 155 rows and 30 columns with lots of information and I need to arrange it in this way in order to create a proper chart. Pivot chart isn’t exactly helping me much.
Thank you
PS: Sorry about the formatting of the table. it does not display properly. Each column is separated by '|'. the numbers at the beginning of each line represent the row number. Hope it helps to understand the data set.
Last edited:
