Hi there, I have tried searching MrExcel for an answer, but have not found one.
What I have is a spreadsheet with seven different different worksheets. Each worksheet contains a large list of manager names, linked to employee names, etc (columns A to H are filled with data).
What I would like to do is in Sheet1, use a Combo box to select a manager's name; and once done, I would like Sheet2 to Sheet7 to automatically filter the other worksheets with the same manager's name.
I thought this would be easy, this is something I have not done before, so I am at a loss of how to proceed.
Oh, and I am using MS Excel 2007.
What I have is a spreadsheet with seven different different worksheets. Each worksheet contains a large list of manager names, linked to employee names, etc (columns A to H are filled with data).
What I would like to do is in Sheet1, use a Combo box to select a manager's name; and once done, I would like Sheet2 to Sheet7 to automatically filter the other worksheets with the same manager's name.
I thought this would be easy, this is something I have not done before, so I am at a loss of how to proceed.
Oh, and I am using MS Excel 2007.