Hi all. I have 7 different drop down lists in one sheet. In another sheet, I will have 7 different dates in a column. Depending on a cells date, I need to have one of the 7 different drop down lists appear in another cell. Example:
Sheet 1 will have several different columns with one column having dates. The dates will be in column M. Depending on the date in cell M3, I would like drop down list 1 show up in cell L3. Date in cell M4 and drop down list 2 show up in L4. Column M will be several dates long (down to M200 or so). How would I accomplish this? I have the drop down list data in sheet 2.
Sheet 1 will have several different columns with one column having dates. The dates will be in column M. Depending on the date in cell M3, I would like drop down list 1 show up in cell L3. Date in cell M4 and drop down list 2 show up in L4. Column M will be several dates long (down to M200 or so). How would I accomplish this? I have the drop down list data in sheet 2.