How to display a named range from selection of drop down menu

Hi there!

I’m trying to populate a named range of cells when selecting a name from a drop down menu. Now, I’ve spent the better part of two weeks trying to figure this out and I haven’t found anything that works. Cry

The menu lists (5) milestones within a project. I have the named range of cells in a second worksheet within the same workbook. 

The data from the second worksheet has been formatted and colored, does that affect anything? I’m a novice, can you tell?




By: Leilanie

Leave a Reply

Your email address will not be published. Required fields are marked *