I have a raw data query that is being dropped into an excel sheet and
then i want to have a seperate sheet within the workbook to have user
run reports. I want to have a data validation cell/combo box reference
the range in the raw data query and only allow distinct values to be
selectd in the drop down.

i.e. the raw data list might have:

Mike
Mike
Paul
Mike
Paul

Data Validation cell that references the above shows:

Mike
Paul

Any ideas/thoughts how to get this done?