Posts by chubbychub

    the spreadsheet I have works but it has blank spaces from the drop down list, I want it with dynamic range in the list, but want to get rid of the blank spaces when picking on the drop down.
    For example, I added this formula:


    =OFFSET(Sheet3!$H$2,0,0,MATCH(Sheet3!$H:$H)-1,1)


    in the "Base_Sink" name range


    instead of this:


    =Sheet3!$H$2:$K$1000


    why it don't work? my purpose is to get rid of the blank spaces when picking from the drop down list and I read in tutorials to add a dynamic range, but don't know why it don't work.
    Please see attachments.