People working in Microsoft Project will often also be working with many Microsoft Excel spreadsheets that contain project data. When these datasets are large, it can be cumbersome to find specific values. The Find on Excel Sheettools were built to allow a user to select a sought after value in MS Project and instantly find the value(s) in their active Excel spreadsheet.
Find on Excel Sheet Quick Button
Clicking this button will do one of the following:
If a single cell in MS Project is selected, the value of that cell will be searched for and (if it exists) be selected on the active Excel spreadsheet.
if multiple cells in a column are selected in MS Project, the active Excel spreadsheet will be filtered for the values selected.
Clicking this button will always search the active Excel worksheet for the value of the first cell in the active selection in Microsoft Project. If the value exists in the spreadsheet, it will automatically be selected.
