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.
1.Read Excel B save id as Variable
2.Read range Excel B store output as Data table
3. Now go to Excel A - use Filter put Excel B id variable as Filter criteria
4.Write range in Excel A - use stored datatable variable