You can use PowerShell to search for various pieces of data within an Excel workbook to include all of the worksheets, which can be useful to quickly determine how much of a particular piece of data ...

Launching a PowerShell Script from Excel, Revisited We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell.