I have created an automation that grabs data from 2 different web page sources for information about soccer players. Those two automations are separate and does not interfere with each other. However in the end I would like the scraped datatables to be put into the same excel workbook.
Problem is that one web page is in English and one is in Japanese, so it would prove difficult to use the same automation for both web pages (thus why I created 2 separate) and now I have come across the problem of trying to merge both excel workbooks into a single workbook.
If anyone knows a fix around this problem, either if it is the merging of the excel workbooks or if there are any other tips on how to extract the data and put it into a single workbook from the start, anything would help.
For more context, the way the datascrape works is that I first extract all the Japanese written soccer player names, extract to a datatable, translate them through google translate in a for each row and paste the name into the workbook + rename the file. This however also get miss-translated sometimes, but that is another question.
Any help would be appreciated!
Transferring the A+B column to the other workbook’s C+D column