Hi all,

I have gone through the forum items looking for something similar to my situation to no avail. Hoping someone can assist with my latest issue.

I have a Project Workbook with the first page being a dashboard. Within the Dashboard I would like to highlight jobs for the current week.

I want to select a date from a drop down in the dasboard which will list "Week Of". I want it to look for jobs scheduled for that week in sheet 2 Column I and pull certain data from that row, such as Column A, Column B, Column C, Column D, Column F, Column J and Column L.

Is this possible?

Thanks in advance
juni