I’m learning about automation in excel.
I have problem with my case.
First, I want to find name “zoe” in file named “2.xlsx”
Second, I want to get value from ‘C2’ and ‘C4’ in file named “2.xlsx”
Third, In file named “1.xlsx”, I want to input value ‘C2’+‘C4’ in ‘B2’ cell.
Could you tell me how to do this?
I would like to know ,
How can I get multiple value which is conforming to the condition in two different excel files.