Data Validation List with only non-blank cells

Originally Posted by ChemistB

Try this

=OFFSET(Sheet1!$D$1,0,0,COUNTIF($D$1:$D$500,">"""),1)

Does that work for you?

Works perfect! Thanks!