I'm using data validation that is pulling a list from another worksheet. The validation parameters are set
For 100 rows of information. However, I may not always have data in all 100 rows. I'm curious if there was a way to keep my data validation drop down list from containing those blank spots. I tried to ignore blank cells but that isn't doing the trick. I'm wondering if there might be a more clever way of doing the drop down menu.

Thank you,

Tim