If you have the expiry dates or the # days remaining in a single column, you can use Excel's filtering tools to filter that column according to whether the date/days falls within your 20-day parameter. No need for an extra sheet. Conditional formatting could also be used to automatically highlight items with less than 21 days remaining.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|