Can you tell me how to search entire workbook and return all records which match a certain value from a drop down list with or without a Macro? e.g. if we have a list of many large organization in a worksheet and have a list of all of their employee, first name, last name, phone, email, title,..... ( many per organization) in another worksheet. How one can see the records of all employees in an organization by selecting the organization's name from a list or drop down box, etc. I would appreciate if your insights.
![Playlist 카페에서 듣기 좋은 잔잔한 음악 [Lo-Fi] Radio](/img/n.gif)
Can you tell me how to search entire workbook and return all records which match a certain value from a drop down list with or without a Macro?
e.g. if we have a list of many large organization in a worksheet and have a list of all of their employee, first name, last name, phone, email, title,..... ( many per organization) in another worksheet.
How one can see the records of all employees in an organization by selecting the organization's name from a list or drop down box, etc. I would appreciate if your insights.