Forum

Notifications
Clear all

Link Data from one Workbook to another Workbook

2 Posts
2 Users
0 Reactions
200 Views
(@donjingle02)
Posts: 1
New Member
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
(@questvba)
Posts: 125
Estimable Member
 

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: 

BR,

Lionel

 
Posted : 28/03/2021 7:13 am
Share: