Hi everyone,
I have two Excel workbook files.
The first one named A have four columns: Q1, Q2, Q3, Q4. I have another file named B that only has one column named TOTAL. When I enter information in four columns in file A then the file B can calculate SUM of the four columns automatically. I don't know if Excel has such a feature to link two Excel files or any sheets whether on the same file or different.
Regards,