I currently have a For Each loop that takes a list of people’s names from excel, searches them on a website, and data scrapes the table that appears on the website and then appends range to a new, empty excel workbook. Using append range is very ugly as there are many lines to each table and its hard to see where one ends and the next begins.
So my question is: Is it possible to create a new sheet in the same workbook for each iteration? Preferably with the person’s name as the sheet name.
So I would have a sheet with John Smith’s info table called John Smith then another sheet called Jack Johnson with that person’s table info ect.