Vba

Thanks for the quick reply. For example, I may have a workbook with a column that contains Sales Order Numbers. There may be another workbook on our network that contains Information relating to manufacturing shortages for Sales Orders. I want to be able to select a Sales Order Number in a cell in the first workbook, and have the second workbook open, subfiltered to show only the shortages for the Sales Order in the selected cell.

Hope this helps