My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Link Data from one Workbook to another Workbook|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Link Data from one Workbook to another Workbook|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Link Data from one Workbook to another Workbook
Avatar
Don Jingle

New Member
Members
Level 0
Forum Posts: 1
Member Since:
March 27, 2021
sp_UserOfflineSmall Offline
1
March 27, 2021 - 11:30 am
sp_Permalink sp_Print

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.

Avatar
Lionel Baijot
Member
Members
Level 0
Forum Posts: 126
Member Since:
September 9, 2020
sp_UserOfflineSmall Offline
2
March 27, 2021 - 9:13 pm
sp_Permalink sp_Print

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

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Chris Holt
Michael Kirby
Malcolm Lambeth
Waqas Arshad
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Forum Stats:
Groups: 3
Forums: 25
Topics: 7157
Posts: 31386

 

Member Stats:
Guest Posters: 50
Members: 34658
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen