Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
200
Views
Topic starter
How to sum up the total amount from Workbook 1 and Workbook 2, then I wanted to post the result in Workbook 3.
I am expexting that if the total amount in Workbook 1 and 2 changes, the total amount in Workbook 3 should change authomaticaly.
I am using Microsoft Excel 2016.
Posted : 27/03/2021 9:30 pm
Hi,
Answering the question at time X is very easy. The problem will come as soon as the data will be modified, will evolve, will grow... The easiest way would be to use Power Query which will allow you to automatically retrieve the data from your files 1 and 2 and add them in file 3.
You could already see these two links:
- https://www.myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-query
- https://www.myonlinetraininghub.com/power-query-consolidate-excel-sheets
BR,
Lionel
Posted : 28/03/2021 7:13 am