I have a project I am working on and cannot seem to find a way to filter my data. On sheet 1 cell B2 I have text. On sheet 2 Column D I need to filter that based on what is in Sheet 1 B2. The problem I am running into is the data in the column only contains what is in Cell B2 on sheet 1. How can I filter this through VBA?