My question is: How do I create a new excel file as part of an each row function? I.e. looking up and scraping data and then pasting this in a newly created excel file.
I have created an automated process which starts with an Excel file with 500 company codes, using a for each row function it then finds a company code enters this company code into a website, looks up the information on the website for this company and then scrapes the company information from the website. I am looking to add an additional step: for each of the unique company codes I’d like to create a new excel file where the scraped data for that company is then pasted, thus at the end of the process having 500 excel files with unique names and unique scraped company information. Is there a way to do this? The closest solution that I’ve found is: Creating Excel File with Dynamic Names but I can’t quite figure out how to get this to work. Another solution that I’ve seen is a combination between create file and the assign function.
Many thanks in advance to anyone who can help me out!