I have several excel files:
excel A: an overview of all files
excel B, C, D, etc.: excel files which contains values that need to be copied to excel A.
The excel files B,C,D contains an ID which can be found in the overview sheet.
Is there any other way to let the bot store the value of excel B, look it up in excel A and fill in columns X,Y,Z
I would want to first open excel B and then fill in the data in excel A.
Thanks in advance,