I'm using a form control drop down on a worksheet titled "Docket Sheets", which lists data from column "A" on my "Template" worksheet. I was curious if anyone is aware of a formula or other way to remove the dead spaces from the drop down so that it will only display the visible data options? The data could change in column "A", meaning I could have 1, 2 or 150 or more numbers in that column, but the data will always begin in cell A3 down. So I would like the dead spaces from A1 and A2 gone in the drop down as well as any empty cells after the data ends, etc. I have other formulas in the other worksheet that associate with both the Column A data along with data in Column C in the "template" worksheet. So when using the drop down menu and selecting an ID number the formulas in the "Docket" sheet associate row data, etc. So I cannot just use a formula to move the data in column "A" up to cell one, without opening a lot of other issues. I'm hoping this question is being asked in the correct forum and any suggestions would be appreciated if this is possible.
Thanks in advance!
Bookmarks