Hello, I have the following code and I am having trouble figuring out how to change it so I can put in a list of different names in the search and have the results show up on different rows.
Example: This code will add a new worksheet with the following info
Workbook, Worksheet, Cell and Text...