How to achieve this scenario- need to interact with 3 excel files at a time--Fill the result template(excel A) by searching the answers(from excel B) and the required fields from Excel C

Help
1

Fill the result template(excel A) by searching the answers(from excel B) and the required fields from Excel C

image
image1210×953 64.2 KB
-
Excel A
image
image1916×1002 147 KB
– Excel B
image
image976×657 38.7 KB
- Excel C

by referring to Answer column of the corresponding question in Excel C and the data from the Excel B, We need to fill the template of Excel A

2

Is excel C populated automatically from excel B? I don’t really understand the relation there.

Either way, you can use excel’s read cell activity to read the information from excel B/C. Do this for all variables you will need. Then use the excel write cell activity to write all of the variables into excel A.

I see there are userforms being used though instead of just cells. RPA does not do well with things that aren’t simple sheets. They don’t interact with objects, active x controls, and userforms very well in my experience. To be honest this seems to be entirely within excel and is likely more suited to VBA