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?
Bookmarks