I'm trying to create a new Excel Output File that contains the calculation taken from 2 different excel files.
Basically, I want to output the result of the following:
Excel File1 (A1) + Excel File 2 (A1) = Output File (A1)
Excel File1 (A2) + Excel File 2 (A2) = Output File (A2)
Excel File1 (B1) + Excel File 2 (B1) = Output File (B1
and so on...
Appreciate if you have any ideas on how to create a macro for this scenario to call Excel File1 and Enter A1 then Call Excel File2 and Enter A1 then Output in in the new Output file.