View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier michaelberrier is offline
external usenet poster
 
Posts: 63
Default Data validation list using filtered range

I have a sheet that populates a data validation in-cell drop down with
a named range of dates. This list of dates is quite long and
historical, but I only need to be able to see the last 14 days in the
drop down list. How can I set it up to filter this range in the drop
down?

Thanks,
mb