I am looking for a VBA code to search through 3 columns and search for a text string. In column a, I would like to search for 596Y. If it is found, I would like to create a tab for that line of data and include the header. Then for the next search, I need to look in Column B to find a list of...