I hope I have the right forum. I created a drop down list in excel 2013 but I want to link specific data to each selection in the dropdown box to be displayed in other boxes on the spreadsheet. I have the dropdown list on a separate sheet from where I store the data to be displayed.
select 1 and populate a,b,c,d
select 2 and populate e,f,g,h
select 3 and populate I,j,k,l
sales area/ employees
south/ Bob, Jane, Russ
North / Jeff. Carl, Pat
West/ Richard, Matt, Josh
When I pick South I want the corresponding employees to be displayed..
I want to link 5 items to the drop down list selection. The data is arranged in a row (left to right) but I have the display boxes arranged in columns (top to bottom). I can change that if need be. only one dropdown box will be used.
I have used excel before but still a novice at most of the more intermediate functions.
I hope that makes sense
Edited by jpd9930, 18 February 2015 - 01:19 PM.