Thread: Identify upcoming date and return value to proper worksheet

Hi,

The attached workbook contains the following worksheets:

• Travel
• Project Schedule
• Employees

On the 'Travel' worksheet, are these lists:[LIST][*]'Departing Today'[*]'Arriving Today'

I need to identify the name(s) of the employees in the 'Project Schedule' worksheet who are arriving/departing based on the 'todays date' cell value and return these names to the arriving/departing list in the ‘travel’ worksheet.

Thanks