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.
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?