In the attached spreadheet, I have a dynamic range defined which populates a dropdown
https://dl.dropboxusercontent.com/u/...Dashboard.xlsm
Dynamic Range Is
=OFFSET(Projects!$C$1,1,0,COUNTIF(Projects!$C:$C,">""")-1,2)
This populates a drop down in the Dashboard TAB under label Project ID & Name. In the code linked to this dropdown I have the following
This all works fine when I have only this one workbook opened, but as soon as I have a second spreadsheet open I start getting runtime errors related to the dynamiclist range, e.g belowPlease Login or Register to view this content.
Runtime_error.png
Bookmarks