I currently have a Look Up Sheet that will search all other 11 sheets in my workbook for information regarding mineral content in different material specifications. I am looking to add on the Look Up Sheet to include another category to look up. I want to create a completely separate module to do this though and that is the part I am stuck on. All I need to do is search 1 sheet for the product code that is entered by the user into the Look Up Sheet. The current Look Up Sheet has a filter/unfiltered feature that hides any rows that do not have any data in them. Can someone help with the module and then explain how the filter/unfiltered feature would work?

Thanks!!!