Spreadsheet

Is there a way to use a picklist (Dialog box) using a spreadsheet which changes every day to select a value from 1 column.