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.