I have a spreadsheet containing a worksheet (Applications) that has a
reference number E1,E2,E3 etc in column A in cells A3:A102. Cells C3:1C102
will contain a name but may not.

I want to create a Validation ldrop down list on another worksheet (Menu)
that only contains the reference number A3:A102 if there is a value in the
cell C3:C102.

Is there anyway of doing this?

At the moment my validation list contains blanks, as i have put an if
formula in the A3:A103 range to put blank if the C3:C102 cell is blank.